One Star

[resolved] Splitting a file into multiple files -

Hi All,
I have a requirement which I am not sure if is feasible to achieve using Talend. 
I have an input file named as "FOOD_DETAILS" whose data need to be extracted and stored in multiple tables depending upon its content.
Content is something like this -
APPETIZERS
----------------
"TX","aaa","100","","","XXX"
"CA","bbb","101","","","XXA"
"NJ","ccc","102","","","XXB"
SNACKS
-----------
"100",,,,"abc","a111",,,
"101",,,,"ccc","b222",,,
I want to split this file into 2 named - APPETIZERS and SNACKS - containing the data present below their headings.
File-1 : APPETIZERS
"TX","aaa","100","","","XXX"
"CA","bbb","101","","","XXA"
"NJ","ccc","102","","","XXB"
File-2 : SNACKS
"100",,,,"abc","a111",,,
"101",,,,"ccc","b222",,,
Let me know if you need any further inputs on my requirement.
Help is much appreciated!
Thanks & Regards,
RB.
1 ACCEPTED SOLUTION

Accepted Solutions

Re: [resolved] Splitting a file into multiple files -

You may use tmap and solve your problem.
This link may helpful
https://www.talendforge.org/forum/viewtopic.php?id=47882
2 REPLIES

Re: [resolved] Splitting a file into multiple files -

Yes, It is possible. You have to use mediation perspective in order to achieve your requirements.

Re: [resolved] Splitting a file into multiple files -

You may use tmap and solve your problem.
This link may helpful
https://www.talendforge.org/forum/viewtopic.php?id=47882