Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New 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
Highlighted

Re: Searching Pattern in Data

This gives us

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


Capture.PNG

View solution in original post

6 Replies
Highlighted

Re: Searching Pattern in Data

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

Highlighted

Re: Searching Pattern in Data

One option can be to try this

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

Re: Searching Pattern in Data

Or this

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

Highlighted
New Contributor

Re: Searching Pattern in Data

Hi Thanks Sunny.

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

Highlighted

Re: Searching Pattern in Data

This gives us

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


Capture.PNG

View solution in original post

Highlighted
New Contributor

Re: Searching Pattern in Data

using text function this will give aswer :

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