Good day.
I’m not too good at explaining, but here goes:
I am trying to open a csv file in Calc. This file was created from the output of SLQCMD.EXE, is delimited with tilde (~) and has CR/LF line ends. Fields are variable length. The first field of each record is an 8 digit number and the last field
is. There are several other fields with the value NULL in each record.
The problem I am having is that in some records there is one field containing one or more CR/LF mid-field. Calc is creating a new record at each instance. I would like to replace the mid-field CR/LF with space ’ '.
I have tried opening the file in Calc, selecting the problem field and using Replace in column mode search for various combinations of \n, \r, \n\r, \r\n, [:cntrl:] Ctl-M, regular expressions checked. This did not work.
I have also tried sed, tr, and grep to no avail although I don’t really know what I am doing.
The only method that has come close to working is to open the cvs file in vim and using substitute like:
%s/\n/ /g where is each character on the keyboard one at a time.
I hope this makes sense… Any ideas appreciated!!
Thanks,