Search Results

sorry if i misunderstood expression, but would

who|grep -v "user name"|awk '{print $1}' suffice?

I have a ascii file with lines like this:
240|^M\ ^M\^M\ Old Port Marketing order recd $62,664.- to ship 6/22/99^M\

when this record gets loaded into my database, the \ is stored literally and so...

i think i get the gist, i was able to use this script to clean up a few other anomalies as well.

thank you very much, i was to the point of asking the users if they really needed those records......

Just a comment on the comma delimited issue, i am no PERL or XLM person, but if you delimit with | instead of commas, your , and " issues go away and very rarely do people store | (pipes) in their...

sweet! looks like voodoo to me, if you have the patience to explain what that script did, i would love to learn more about it.

thank you very, much!!!!

thanks, this has been really helpful, but i need to run this on several files that have >1000000 records, which i can break down into smaller files if need be (migrating data in case you haven't...

thanks, but it does not join all of the ^Ms

240|^M\
^M\
^M\
Old Port Marketing order recd $62,664.- to ship 6/22/99^M\
^M\
^M\
^M\
^MCompleted by: C. Malczynski|


becomes:

240|^M\...

in vi, if i type ctrl-J, i can shift the next line up to the current line.
I need to do this whenever a specific string exists (in particular ^M) ,however i have not been able to find a way to do...