topic Re: How to remove blank spaces between lines or between strings. in QlikView

How to remove blank spaces between lines or between strings.

Wed, 18 Feb 2015 05:15:41 GMT

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

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

Re: How to remove blank spaces between lines or between strings.

anbu1984 — Wed, 18 Feb 2015 05:42:35 GMT

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 ];