topic deleting multiple spaces in QlikView

deleting multiple spaces

Fri, 04 Jun 2010 14:48:36 GMT

Hi, i need help.

I've red more discussion that tells how to purge strings from character, but i can't solve my problem.

I have a column of stringd that contains multiple white spaces sequentially and not, i need to sobstitute every white spaces with only one space.

Can anybody help me?

For example i have this string: 'AMAT IMPIANTI DI GRAZIELLO S.N.C. .'

and i need to obtain this one 'AMAT IMPIANTI DI GRAZIELLO S.N.C.'

thanks

Thanks

AW:deleting multiple spaces

biester — Mon, 07 Jun 2010 07:59:05 GMT

Ciao Cesare,

I'm afraid there is no built in string manipulation function which can handle this in one step. I would write a macro with a custom function and use it in the script. Another possibility would be a loop in the script using built in functions.

Rgds,
Joachim

deleting multiple spaces

SunilChauhan — Mon, 07 Jun 2010 09:02:48 GMT

i think this may work fine

replace

(col,' ',' ')

AW:deleting multiple spaces

Mon, 07 Jun 2010 09:26:34 GMT

Thanks Joachim!

I will build a macro that do what i need!

deleting multiple spaces

Mon, 07 Jun 2010 10:50:27 GMT

replace(replace(replace(column_name,' ',' '),' ',' '),' ',' ') as data

i use nested replace to get rid of multiple spaces .Its working ,but not a good solution..

Thanks

deleting multiple spaces

Mon, 07 Jun 2010 10:52:55 GMT

i remove double spaces with single space and re-iterate with nested with replace functions.its working....