Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
////////////////////////////////////////////////////////////////
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 ];
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 ];