"It didn't work" doesn't tell us very much.  How did the results differ from 
what you wanted?

Is it always four blanks in field 1, two in field 2, two in field 3, and 2 in 
field 4?  Is the length of each field constant across all the records?  If so, 
then does
    BUILD=(5,8,15,5,22,21,45,5)
come close to what you want?

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of 
Ron Thomas
Sent: Monday, September 5, 2022 10:31 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: dfsort - Reformat file

Hi ,

We have a input PIPE DELIMITED file as follows of lrecl = 80. Need to remove 
the leading spaces with out disturbing the 3 column values

....1652087|..0049|..OPTICAL             |..0170|
....2130994|..0006|..STATIONERY          |..0716|
....2199447|..0078|..SERVE OVER PIZZA    |..0410|
....2199449|..0078|..SERVE OVER PIZZA    |..0410|

o/p has to be

1652087|0049|OPTICAL             |0170|
2130994|0006|STATIONERY          |0716|
2199447|0078|SERVE OVER PIZZA    |0410|
2199449|0078|SERVE OVER PIZZA    |0410|

i used OUTREC BUILD=(1,80,SQZ=(SHIFT=LEFT)) and it didn't work out

Could someone pls let me know how to make this ?

Thanks
Ron T

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to