Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Ayoub
New Contributor III

Delete Words

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

5 Replies
saminea_ANZ
Contributor

Re: Delete Words

Please provide 10 rows and expected result?

Highlighted
Ayoub
New Contributor III

Re: Delete Words

@saminea_ANZ 

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
Contributor

Re: Delete Words

Try this?

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

gf
Contributor III

Re: Delete Words

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
MVP & Luminary
MVP & Luminary

Re: Delete Words

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

- Marcus