Replace URL with number extracted from the URL

Question

Hello,

I have recently started using your tool, but have a problem that I have so far been unable to solve and was wondering if someone could help me with it. I run a regular report, and one of the columns returns a URL. The URL is identical for all the rows, except for a 6 digit number in it.

Sample of the URL is:

<a href="http://abcdefgh01:8080/ertyu/forms/milkyway/ops-TP+Escalation/Default+Administrator+View/?qual='1'="112327"" target="_blank">112327</a>

The Part I am interested in is the 112327, and ideally I would want to replace the URL's with only the number from those URL's. How would I be able to achieve that?

Thanks,
dsab85