Remove sauce using SORT.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.

Topic author
Dark Fantasy
New Member
Posts: 8
Joined: Sun Dec 08, 2013 12:54 am
Has thanked: 2 times

Remove sauce using SORT.

Postby 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: 523
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 11 times

Re: Remove sauce using SORT.

Postby 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


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

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests