Looping through fields in a job while using RTP
Posted: Fri Jun 11, 2021 3:22 am
Hello All
I have an ascii fixed width file with 8 fields. I want to convert that file to a pipe "|" delimited file removing leading and trailing spaces.
I’m using RTP to make the job generic and reusable. Is there a way to loop through the fields from 1 to n?
Thanks in advance for any help.
I have an ascii fixed width file with 8 fields. I want to convert that file to a pipe "|" delimited file removing leading and trailing spaces.
I’m using RTP to make the job generic and reusable. Is there a way to loop through the fields from 1 to n?
Thanks in advance for any help.