topic Re: Replace multiple char in String in QlikView

Replace multiple char in String

Ayoub — Fri, 12 Apr 2019 08:29:05 GMT

Hello Community

i have the table bellow and i want to remove those words 'STE' 'SARL' 'SA' existing in the Start and end of field RAISON_Sociale

i tried 'MapSubString' but in case of the last word 'SA SARLPOK' the result became POK and i want it to Be 'SARLPOL'

Thank you so much for the help

Re: Replace multiple char in String

Gysbert_Wassenaar — Fri, 12 Apr 2019 09:08:04 GMT

Perhaps something like this:
If(Match(SubField([RAISON_SOCIALE],' ',1),'SA','SARL','STE'), Mid([RAISON_SOCIALE],Index([RAISON_SOCIALE],' ')+1),[RAISON_SOCIALE])

Re: Replace multiple char in String

marcus_sommer — Fri, 12 Apr 2019 09:28:35 GMT

I think it might be solvable with mapsubstring by using multiple statements for your adjustments. This means something like to replace 'SARL' at first with an unique char like chr(1) and then checking to chr(1) & 'POK' and replacing it with 'SARLPOK' again and afterwards the chr(1) will be also replaced.

I'm not sure if it could be done within a single mapsubstring - in this case the order of the statements would be important - but with multiple mapsubstrings maybe applied with a chain of preceeding loads it should be possible.

- Marcus

Re: Replace multiple char in String

Ayoub — Fri, 12 Apr 2019 09:58:54 GMT

it works Thank you so Much

Re: Replace multiple char in String

Ayoub — Fri, 12 Apr 2019 16:11:40 GMT

Hey@Gysbert_Wassenaar

What if i want to delete the same words from the right side cause this one works only in the left ?

thank u for ur heelp

Re: Replace multiple char in String

Gysbert_Wassenaar — Mon, 15 Apr 2019 09:36:02 GMT

Yes, this one works just from the left. You can do it from the right with this (I hope):

If(Match(SubField([RAISON_SOCIALE],' ',-1),'SA','SARL','STE'), Left([RAISON_SOCIALE],Index([RAISON_SOCIALE],' ',-1)+1),[RAISON_SOCIALE])