How to remove blank spaces between lines or between strings.

[#1]

Hi,

This is extension to blog .....Replace function: Find Multiple strings and replace to blank

After I replace strings, my table field has lot of blank spaces. Is there any way I can remove those? Please help.

Sample in the file:

///////////////////////////////////////////////////////////

    c c  1c

'02'00. '01

'02'01. '01

'02'02. '01

//////////////////////////////////////////////////////////////

My desired result is below...

////////////////////////////////////////////////////////////

c c  1c

'02'00. '01

'02'01. '01

'02'02. '01

////////////////////////////////////////////////////////////////

[anbu1984 · Accepted solution]

map1:

mapping load * inline [

x, y

happy, ''

dinner, ''

] ;

Directory;

Load * Where Len(Trim(Changed)) > 0;

LOAD

mapsubstring('map1',SalesOrder_Text) as Changed;

Load * Inline [

SalesOrder_Text

happy

dinner  

aaxxyyy

bcd

hello ];