Community

Hi, if this solution is already out here in the forum I apologize in advance, I have been searching for a few days without any success.

I have a cvs file full of records that need to split into a different format


Example

A,B,D,1234
V,S,A,5432

Needs to be in the following format

A
B
D
1234

V
S
A
5432

** Note **
In a nutshell I need to create a four line record, with a blank line between each record

There are several, similar, ways to do this. For example

Find what: ^(.*),(.*),(.*),(.*)$
Replace with: \1\n\2\n\3\n\4\n

[X] Regular expression

Replace All

or (possibly faster)

Find what: ^([^,]*),([^,]*),([^,]*),([^,]*)$
Replace with: \1\n\2\n\3\n\4\n

[X] Regular expression

Replace All

These assume you are using Posix regular expression syntax:

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

Thanks that was the fix that I needed, the solution seems all so clear to me now. Thanks again for helping me out.