Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
bdgeddam9
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

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

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)

bdgeddam9
New Contributor

Re: Searching Pattern in Data

Hi Thanks Sunny.

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

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

bdgeddam9
New Contributor

Re: Searching Pattern in Data

using text function this will give aswer :

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