Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Substring word identifying

Image.JPG

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

1 Reply
Highlighted
Partner
Partner

Re: Substring word identifying

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;