Find + Replace regex question :(

crazzeto · Post by **crazzeto** » Thu Sep 24, 2009 2:25 pm

I have a question about whether something is possible. I was given a flat file to be imported into our companies database. The flat file is in some bizzaro format which was invented by the person that exported it. There is a pattern I can use to get it into CSV format though :

I need to change the regex patter [0-9]\n to [0-9],

So basically I need to look for a number followed by new line and replace that with the SAME NUMBER that was there before and just change the new line to a comma. Is that even possible?

ben_josephs · Post by **ben_josephs** » Thu Sep 24, 2009 5:55 pm

Find what: ([0-9])\n
Replace with: \1,

[X] Regular expression

Replace All

This assumes you are using Posix regular expression syntax:

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

crazzeto · Post by **crazzeto** » Thu Sep 24, 2009 8:07 pm

Thanks so much, that helped