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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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,
  2. densolis

    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...
  3. densolis

    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
  4. densolis

    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...
  5. densolis

    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: ^...
  6. densolis

    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
  7. densolis

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

Part and Inventory Search

Back
Top