Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)