Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by densolis
-
Remove "extra" crlf in windows CSV file.
One other question. How do I replace the extra Cr LF with a ", ". Can I do the same thing with the extra "LF"? Thanks, -
Remove "extra" crlf in windows CSV file.
ok - did that and it output the data to a file. Interesting this is when I looked at the output, the new file was bigger in size according to the directory. Original file 9,214k and had 18,548 lines New file is 9,232k and has 18,411 lines. Also, there are multiple CRLF in a given record. The... -
Remove "extra" crlf in windows CSV file.
Ok, I did what you said above. I then ran the command and all of the output come to the screen and my file was left untouched. Is this what is supposed to happen? Or am I supposed to redirect the output to a file? Like I said, I am just learning how to spell akw. Thanks -
Remove "extra" crlf in windows CSV file.
I download gawk from http://gnuwin32.sourceforge.net/packages/gawk.htm. here is some actual data. Even thought the data is on Windows, the data file terminate with a LF. Or at least that what I can figure out from displaying the data in hex in notepad++ Here is the header line and one line of... -
Remove "extra" crlf in windows CSV file.
Hi, As I said earlier, I do not know how to use awk. I downloaded gawk from SourceForge and install installed it. I entered the following and got the following error: C:\Renco\VAX\TXT Files\awk>gawk '{nq=gsub(/"/,"&");if(nq%2){x=$0;getline;$0=x $0 }}1' input gawk: '{nq=gsub(//, gawk: ^... -
Remove "extra" crlf in windows CSV file.
PH, Ah - how obvious (not). I will start playing with your command and see if I can figure out what you are doing and then I will try it. Can your recommend a good manual / document / webpage that will help me learn awk? Thanks for your help. Dennis -
Remove "extra" crlf in windows CSV file.
Hi, I am doing a conversion from Sale Force to Oracle on a Windows platform. I saw where I can get a windows version of awk to run on windows from Sourceforge. I do not know anything about awk other than it is a Unix command that does string manipulation. Background: The Accounts (customer...
