Ron, Quite simple. Convert the numeric data to M10 or use an edit mask to replace the leading zeros with spaces. And then use the function SQZ to remove the blanks in between. The output will be something like this
102016|31859949|0|1613QTTR|1|1995-11-13|1|8.0000|C|75|19.0000| Thanks, Kolusu > Hi . > > We have a below PIPE delimited file , let me know how to remove the > leading zeros and spaces zeros from this file ? > > 0000102016|0031859949|0000000000|1613QTTR |00001| > 1995-11-13|0000000001|000000008.0000|C|0000000075| 00000000019.0000| > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
