Hi! I have the file with Fb format having data as below, I want to enclose each data element with double quotes ("") and comma between each value for .CSV format conversion.
Joined: 15 Aug 2015 Posts: 1335 Location: Bamberg, Germany
Are the fields floating, or is it just fixed lengths as shown? If fixed length, then why not just use BUILD=(p,m, ..), and insert the missing characters?
Hi! I have the file with Fb format having data as below, I want to enclose each data element with double quotes ("") and comma between each value for .CSV format conversion.
Thank you all for your suggestions, i did try to do with outrec build, somehow the jcl throwing errors. Finally, i used inrec build =(1,10,JFY=(SHIFT=LEFT,LEAD=C'"',TRAIL=C'"', LENGTH=12),C',').....SO on and it gave the result as I wanted
It would be also nice if you:
0) presented here THE EXACT COPY of what you tried, and what you've got?
1) explained what "somehow the jcl throwing errors" stands for?
2) explained what is the goal of using JFY=(...)?