Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bdgeddam9
Contributor
Contributor

Searching Pattern in Data

Hi i have data as follows and basically need data before "@" and after "/"

us/us 2013/us@2018/uk

1 Solution

Accepted Solutions
sunny_talwar

This gives us

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)


Capture.PNG

View solution in original post

6 Replies
sunny_talwar

Since '/' repeats multiple times, which one do you want to consider? In essence what is the string that you would like to pull out?

sunny_talwar

One option can be to try this

=TextBetween('us/us 2013/us@2018/uk', '/', '@')

sunny_talwar

Or this

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)

bdgeddam9
Contributor
Contributor
Author

Hi Thanks Sunny.

I am looking for "us" .I think either of functions gives answer

sunny_talwar

This gives us

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)


Capture.PNG

bdgeddam9
Contributor
Contributor
Author

using text function this will give aswer :

=TextBetween('us/us 2013/us@2018/uk', '/', '@',2)