Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Subject: RE: bash- Removing Line feeds (Carriage returns) from data
Date: Thu, 23 Oct 2003 09:45:04 -0500
Message-ID: <03C99898510C8C47945B932907D99AAA16F037@E2KMEMMCS1.ftbco.ftn.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
From: "DePriest, Jason R." <jrdepriest AT ftb DOT com>
To: <cygwin AT cygwin DOT com>
X-OriginalArrivalTime: 23 Oct 2003 14:45:04.0628 (UTC) FILETIME=[3EDAAB40:01C39974]
X-DCC-FTBDCCD1-Metrics: dns1 1130; Body=1 Fuz1=1 Fuz2=1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id h9NElB9R005893

> -----Original Message-----
> From: cygwin-owner AT cygwin DOT com 
> [mailto:cygwin-owner AT cygwin DOT com] On Behalf Of Jared Ingersoll
> Sent: Thursday, October 23, 2003 9:33 AM
> To: 'cygwin AT cygwin DOT com'
> Subject: bash- Removing Line feeds (Carriage returns) from data
> 
> 
> Hello,
> 
> I'm currently using cygwin (updated yesterday) with a WIN2K 
> resource kit
> utility to dump logs from event viewer into a comma delimited 
> file. One
> behavior that I have noticed (and occasionally notice with cygwin in
> general) is that within the data, there are what I believe to 
> be carriage
> returns (show up in an excel spreadsheet as a square 
> character). This data
> will eventually end up in an Oracle database, so these characters are
> undesirable. I was wondering if there is a way (outside of 
> manually editing
> the file, perhaps with sed or awk) to remove these characters?
> 
> Here's the command that's producing them in the bash shell:
> 
> /cygdrive/d/EventAudit/dumpel.exe -d 1 -s MyPC -l system -t -c |
> /cygdrive/c/cygwin/bin/awk '{print "MyPC" "," "system" "," $0}' >>
> /cygdrive/d/EventAudit/serverevents.`/cygdrive/c/cygwin/bin/da
> te +%Y%m%d`
> 
> I was unable to find any reference to an automated resolution 
> on google or
> cygwin FAQ.
> 
> Thanks for the help.
> 
> Jared

See if 'dos2unix' from the 'cygutils' package does what you need.

-Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/