Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
MVP & Luminary
MVP & Luminary

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

- Marcus