Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ayoub
Contributor III
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
Creator
Creator

Please provide 10 rows and expected result?

Ayoub
Contributor III
Contributor III
Author

@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
Creator
Creator

Try this?

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

gf
Creator III
Creator III

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

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

- Marcus