Combine single field csv into multiple field CSV

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
steve1040
Posts: 39
Joined: Fri Oct 13, 2006 2:19 am

Combine single field csv into multiple field CSV

Post by steve1040 »

I have data that looks like this (1000 rows)
'AAA',
'ABA',
'BBB',
'ABB',
'BAA'
etc

I need it to look like this
'AAA','ABA','BBB','ABB','BAA' (Combine every 10 line )
When complete I should have 100 rows

Is this possible?
Steve
ben_josephs
Posts: 2459
Joined: Sun Mar 02, 2003 9:22 pm

Post by ben_josephs »

Find what: (.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)
Replace with: $1,$2,$3,$4,$5,$6,$7,$8,$9,$10

[X] Regular expression

Replace All
Post Reply