Page 1 of 1

possibly with regex?

Posted: Mon Mar 20, 2006 2:42 pm
by Mart
I am just trying out this software to put some multiline comma delimited files into nice single line comma delimited.

The problem I have is this. Each row is seperated by two carriage returns and a row starts with, first column, either a numeric id or two alpha chars and then numbers.
I need to replace this with single carriage returns, the main problem is that there are some two carriage returns in the main body of some rows.

The other problem I have is that each row ends with a singe carriage return a comma then a carriage return. These need to be removed to make one row.

Can this be done? If so how can I do it?

thanks for taking the time to read.