Pick substring within string.

[surajap123]

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 · Accepted solution]

Hi Suraj. Try this

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

[sunny_talwar]

Also try this

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

[surajap123]

Thanks everyone for the help!