Page 1 of 1

Shorten record (recuce record length)

PostPosted: Fri Oct 25, 2013 8:33 pm
by yakult
Hi,
I have a variable length input file
Some records can have blank at end of record

Input
ABCDEFGH.........
WXYZ..............
123456..........
9876-1234-5555-88
Dots indicate blanks

I need to shorten every record with blanks
The new record length would be equal to the last non-blank character position +4

Output
ABCDEFGH
WXYZ
123456
9876-1234-5555-88

Is it possible with DFSORT/ICETOOL?

Re: Shorten record (recuce record length)

PostPosted: Fri Oct 25, 2013 9:59 pm
by BillyBoyo
Yes, Have a look at OUTFIL VLTRIM

Re: Shorten record (reduce record length)

PostPosted: Tue Oct 29, 2013 12:22 pm
by yakult
Thank you Billy Boyo!

This is just what I need.

Have a nice day.