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
Message-ID:	<4FF77D01E13B214590F4FA3E2C3021D0873AB9@pecos.csw.alewife.net>
From:	Jared Ingersoll <jared AT cswv DOT com>
To:	"'cygwin AT cygwin DOT com'" <cygwin AT cygwin DOT com>
Subject:	bash- Removing Line feeds (Carriage returns) from data
Date:	Thu, 23 Oct 2003 10:32:48 -0400
MIME-Version:	1.0
X-OriginalArrivalTime:	23 Oct 2003 14:32:48.0885 (UTC) FILETIME=[88513250:01C39972]

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/date +%Y%m%d`

I was unable to find any reference to an automated resolution on google or
cygwin FAQ.

Thanks for the help.

Jared

--
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/

- Raw text -