topic Re: Searching Pattern in Data in QlikView

Searching Pattern in Data

bdgeddam9 — Thu, 26 Jul 2018 14:49:00 GMT

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

sunny_talwar — Thu, 26 Jul 2018 15:04:55 GMT

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 — Thu, 26 Jul 2018 15:05:09 GMT

One option can be to try this

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

sunny_talwar — Thu, 26 Jul 2018 15:05:47 GMT

Or this

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

bdgeddam9 — Fri, 27 Jul 2018 12:40:14 GMT

Hi Thanks Sunny.

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

sunny_talwar — Fri, 27 Jul 2018 12:52:29 GMT

This gives us

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

bdgeddam9 — Fri, 27 Jul 2018 13:10:14 GMT

using text function this will give aswer :

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