topic Re: Remove blank spaces between a string in QlikView

Remove blank spaces between a string

Ayoub — Fri, 12 Apr 2019 14:20:13 GMT

Hello Community

if i have too much space between 2 String like that 'new quest'

and i want to get this result 'new quest' with one space between new and quest.

How can I do that ?

i Did this : SubField('new quest',' ',1)& ' ' &SubField('new quest',' ',2) but it works only with one space between the two words

Thank you Again

Re: Remove blank spaces between a string

m_woolf — Fri, 12 Apr 2019 14:48:00 GMT

Something like this:

Left(index(String,' ')-1) & ' ' & mid(index(String,' ',-1)+1)

Re: Remove blank spaces between a string

Vegar — Fri, 12 Apr 2019 14:55:03 GMT

This will work

= SubField('new     quest',' ',1)& ' ' &SubField('new     quest',' ',-1)

Re: Remove blank spaces between a string

Ayoub — Fri, 12 Apr 2019 15:09:21 GMT

Hello @Vegar
thank you for ur answer it works like magic but what if i had 3 words
cause in the application which i'm working on .; i shoud delete all blank spaces between the words and i could have 3 or 4 word in one String 😕

(Sorry abt my english)

Thank you again

Re: Remove blank spaces between a string

Vegar — Fri, 12 Apr 2019 15:39:47 GMT

I have not verified it, but this might do the trick

Concat( trim(subfield( Field, ' ')), ' ')

BR
Vegar