topic Re: Pick substring within string. in QlikView

Pick substring within string.

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In the below data, i want to pick the string present between /abc/ and #.

The output should be similar to expected output column.

Please help with the expression.

andrey_krylov — Wed, 07 Nov 2018 10:34:54 GMT

Hi Suraj. Try this

SubField(SubField([link], '/abc/', 2), '#', 1)

sunny_talwar — Wed, 07 Nov 2018 12:08:16 GMT

Also try this

=TextBetween(link & '#', '/abc/', '#')

surajap123 — Wed, 07 Nov 2018 21:08:14 GMT

Thanks everyone for the help!