Substring word identifying

[santhana]

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

[nsetty]

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;