Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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', '/', '@')

Highlighted

Re: Searching Pattern in Data

Or this

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

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)