How to parse the record

, ,
1

Hello,

Could you pls tell me how to parse the record when the recid is the last element?

The same data could be:

india, newdelhi ,99
pakistan, islamabad,99
india,rupee,00
us,dollar,00

the format will be
,,
,,

Please help, I am looking to parse the file when the recid is the last element?
Share your inputs for how best this can be parsed
Regards,
Sasanka

2

Just set it in the field Record Identifier on the first tab of the flat file schema, in your case nth field = 2.

3

Thanks a lot…