Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , 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-Injected-Via-Gmane: http://gmane.org/ To: cygwin AT cygwin DOT com From: "Joe" Subject: Re: bash- Removing Line feeds (Carriage returns) from data Date: Thu, 23 Oct 2003 11:17:44 -0400 Lines: 32 Message-ID: References: <4FF77D01E13B214590F4FA3E2C3021D0873AB9 AT pecos DOT csw DOT alewife DOT net> X-Complaints-To: usenet AT sea DOT gmane DOT org X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Try piping to: tr -d '\r' "Jared Ingersoll" wrote in message news:4FF77D01E13B214590F4FA3E2C3021D0873AB9 AT pecos DOT csw DOT alewife DOT net... > 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/