Remove sauce using SORT.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic Author
Dark Fantasy
New Member
Posts: 8
Joined: Sun Dec 08, 2013 12:54 am

Remove sauce using SORT.

Post by Dark Fantasy » Thu Apr 13, 2017 3:43 pm

Hi,

Please have a look at below input:

Code: Select all

SCLA         SCLA             SCLA              
SCLA            SCLA 9        SCLA              
SCLA         SCLA             SCLA             
output should look like this:

Code: Select all

SCLA         SCLA             SCLA              
SCLA         SCLA 9           SCLA              
SCLA         SCLA             SCLA
Could someone please help me on this how to do that?




nicc
Global Moderator
Global Moderator
Posts: 583
Joined: Wed Apr 23, 2014 8:45 pm

Re: Remove sauce using SORT.

Post by nicc » Thu Apr 13, 2017 5:08 pm

Use PARSE to split the fields and then use BILD to concatenate them as you want.


Regards
Nic

Previous topicNext topic

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”