Shorten record (recuce record length)



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Shorten record (recuce record length)

Postby yakult » Fri Oct 25, 2013 8:33 pm

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?
yakult
 
Posts: 2
Joined: Fri Oct 25, 2013 5:38 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Shorten record (recuce record length)

 

Re: Shorten record (recuce record length)

Postby BillyBoyo » Fri Oct 25, 2013 9:59 pm

Yes, Have a look at OUTFIL VLTRIM

These users thanked the author BillyBoyo for the post:
yakult (Tue Oct 29, 2013 8:11 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Shorten record (reduce record length)

Postby yakult » Tue Oct 29, 2013 12:22 pm

Thank you Billy Boyo!

This is just what I need.

Have a nice day.
yakult
 
Posts: 2
Joined: Fri Oct 25, 2013 5:38 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post