Discussion Board for collaboration related to QlikView App Development.
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
Please provide 10 rows and expected result?
LOAD * INLINE [
ST SASOLUTION SARL?
ST ASSURANCE SA,
STE MONDA SA,
STE SAPOK SARL
and the result should be : SASOLUTION , ASSURANCE , MONDA , SAPOK
LOAD *, SubField(BranchName, ' ', 2) as Expected INLINE [BranchNameST SASOLUTION SARL?ST ASSURANCE SASTE MONDA SASTE SAPOK SARL];
Why not trying with (multiple) mapsubstring like suggested here: Replace-multiple-char-in-String?