Split File group by...

Hello,
I have to split a delimited file containing data like :

A;data1
A;data2
A;data3
B;data4
B;data5
I want to split this file to have 2 files (names A.csv and B.csv) containing :
File A.csv :
data1
data2
data3
and
File B.csv :
data4
data5

Someone can help ? Thank U in advance
4 REPLIES
One Star

Re: Split File group by...

You can use a tMap: create 2 output and filter the output on the first column, redirect your two outputs on two new csv files. This should do the trick.

Re: Split File group by...

Thank You, i know how to do that.
I didn't explained enough : i don't know in my source file if i got just A and B, or A, or ABCDEF...
So i don't know how much files will be outputed...

Re: Split File group by...

Just for my information, do you see my email adress as author of this post ?
Six Stars

Re: Split File group by...

I have the same thing want to do? Do you find a solution?