AnsweredAssumed Answered

How can we split the records from a flat file?

Question asked by indrasena on Jun 14, 2018
Latest reply on Jun 21, 2018 by amitash.pattnaik983074

Hi all.

 

How can we split the records from a flat file?

 

Ex: My Source

20003,IND,20180516,20180622,38.00,
20003,IND,20180623,20180730,39.00,
20003,IND,20180731,20180814,15.00,
20007,USA,20180618,20180730,43.00,
30004,IND,20180530,20180629,31.00,
30004,IND,20180630,20180729,30.00,


My output should be like:

 

1st file

20003,IND,20180516,20180622,38.00,
20007,USA,20180618,20180730,43.00,
30004,IND,20180530,20180629,31.00,


the 2nd file

20003,IND,20180623,20180730,39.00,
30004,IND,20180630,20180729,30.00,

 

and the 3rd file is like

20003,IND,20180731,20180814,15.00,

 

Thank you

 

Leif Jacobsen

Outcomes