Page 1 of 1

Remove sauce using SORT.

Posted: Thu Apr 13, 2017 3:43 pm
by Dark Fantasy
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?

Re: Remove sauce using SORT.

Posted: Thu Apr 13, 2017 5:08 pm
by nicc
Use PARSE to split the fields and then use BILD to concatenate them as you want.