Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please provide 10 rows and expected result?
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
Try this?
LOAD *, SubField(BranchName, ' ', 2) as Expected INLINE [
BranchName
ST SASOLUTION SARL?
ST ASSURANCE SA
STE MONDA SA
STE SAPOK SARL
];
Why not trying with (multiple) mapsubstring like suggested here: Replace-multiple-char-in-String?
- Marcus