Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hii to all My Qlik friends
I am facing issue to identify the four character inside the slash / if there is found four character then the four character to be removedand the slash if there is three word then its okay as below values
Try this....
tempdata:
load
*
Inline
[
StringData
123/1234/123/1234/123//
];
TransformedData:
Load
*,
If(Len(TextBetween(StringData,'/','/'))=4, Replace(StringData, TextBetween(StringData,'/','/'), ''), StringData) as NewD
resident tempdata;