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

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, MudGuard

Post Reply
josheeg
Posts: 2
Joined: Thu Oct 07, 2010 8:57 pm

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

Post by josheeg »

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.
User avatar
MudGuard
Posts: 1295
Joined: Sun Mar 02, 2003 10:15 pm
Location: Munich, Germany
Contact:

Post by MudGuard »

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 ...
josheeg
Posts: 2
Joined: Thu Oct 07, 2010 8:57 pm

csv coma seperated value replace column with LF

Post by josheeg »

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.
ben_josephs
Posts: 2464
Joined: Sun Mar 02, 2003 9:22 pm

Post by ben_josephs »

Find what: ,
Replace with: \n

[X] Regular expression

Replace All
laila34
Posts: 1
Joined: Wed Oct 13, 2010 12:22 am

Post by laila34 »

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