I think tr is going to solve it, but now I have to figure out just what character this is.
thanks, jared -----Original Message----- From: Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: Re: bash- Removing Line feeds (Carriage returns) from data Try piping to: tr -d '\r' "Jared Ingersoll" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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/ -- 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/
