possibly with regex?

General discussions about Advanced Find and Replace
Post Reply
Mart
Posts: 6
Joined: Mon Mar 20, 2006 2:34 pm

possibly with regex?

Post 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.
cheers
Martin

Post Reply