Search Results

The goal would be that I can load all lines in the file and that each column/field is delimited by a pipe and each row has exactly 70 col/fields. The data has embedded cr/lf/eol in it. It came from...

added csv file (but its really pipe delimited)

Sorry the error was for akshays code.

Corona688, I tried yours on the sample data and all worked fine. I then tried it on the real file, there are 70 columns/fields in the file. The file has 4688...

Seems to work but I think I am hitting a buffer issue with variable. It gets error ^ ran out for this one on a line and does not process further.

Thanks,
Tim

Thanks!

So the end of line char is $ in vi. So what I really want is I have a file that has 80 fields. In there is free form text that people have added the <enter> key so they show up as cr or...

I have a file
1|2|3|4
a|b|c|d
1|2
3|4
a|
b|
c|
d|

The file should have 4 fields to load into a database. The file may have cr, lf, or end of line characters.

What I want to see as...