Community

Posted: **Thu Oct 07, 2010 9:01 pm**

coma to newline to make a csv file into one colum?

I think OOO base by open office can open a larger csv file than other spread sheets.

Otherwise how would I remove blank lines?

How would I remove repeted records?

I know sql has select the ones that are not empty
then their is also return uneque.

Posted: **Sun Oct 10, 2010 8:36 pm**

Maybe you could state clearly what your problem is.

I can't make any sense of your lines ...
And the number of answers so far might be due to other people also not understandig what you want ...

Posted: **Mon Oct 11, 2010 2:43 pm**

A comma seperated text file can be output from very simple sensors etc.

if the commas were able to be replaced by carage return line feed

their would be one column and many more rows with 1 record.

That is what I would like to do.

Posted: **Mon Oct 11, 2010 4:25 pm**

Find what: ,
Replace with: \n

[X] Regular expression

Replace All

Posted: **Wed Oct 13, 2010 1:10 am**

OK guys thank sfor t6he details,
Btw greetings...how to deal with depression

Community

coma to newline to make a csv file into one colum ?

coma to newline to make a csv file into one colum ?

csv coma seperated value replace column with LF