topic Re: Delete Words in QlikView

Delete Words

Ayoub — Mon, 15 Apr 2019 08:18:55 GMT

Hello community,

I Have some words Like this : 'STE POK SARL' , 'STE SALDARIZ SA'

How can delete those words : STE SARL and SA from both sides ?

i used MapSubString but in the case of 'STE SALDARIZ SA' i have this result 'LDARIZ'

and it's not what i'm looking for

Thank you in advance

saminea_ANZ — Mon, 15 Apr 2019 09:11:37 GMT

Please provide 10 rows and expected result?

Ayoub — Mon, 15 Apr 2019 09:29:23 GMT

for example:

LOAD * INLINE [

BranchName

ST SASOLUTION SARL?

ST ASSURANCE SA,

STE MONDA SA,

STE SAPOK SARL

];

and the result should be : SASOLUTION , ASSURANCE , MONDA , SAPOK

saminea_ANZ — Mon, 15 Apr 2019 09:46:33 GMT

Try this?

LOAD *, SubField(BranchName, ' ', 2) as Expected INLINE [
BranchName
ST SASOLUTION SARL?
ST ASSURANCE SA
STE MONDA SA
STE SAPOK SARL
];

gf — Mon, 15 Apr 2019 12:34:58 GMT

Have a look at the Replace() function.
Just replace your search string with ''.
Example:
Replace(YourWord,'SA','')

May you should have a look at this thread:
https://community.qlik.com/t5/Qlik-Design-Blog/Replace-Function/ba-p/1462640

marcus_sommer — Mon, 15 Apr 2019 12:53:39 GMT

Why not trying with (multiple) mapsubstring like suggested here: Replace-multiple-char-in-String?

- Marcus