How to extract value between asterics in the cell

[Arnold]

Hello


My data has a url column [Url] that looks like this
=HYPERLINK("http://www.amazon.com/Vornado-Replacement-AQS500-Purifier-filters/dp/B000YDJNQA", "http://www.amazon.com/Vornado-Replacement-AQS500-Purifier-filters/dp/B000YDJNQA")

How would I write the formula in the query builder to extract only http://www.amazon.com/Vornado-Replacement-AQS500-Purifier-filters/dp/B000YDJNQA

It would begin ItemUrl:

Thanks

[June7]

That is an expression using a custom function called Hyperlink. Where is that expression - in a textbox ControlSource property? Why does that expression have literal text (the URL address)?

[Arnold]

Thank you

This comes a text form generated by a service that I use. I cant get them to generate it differently.

[June7]

I don't understand "from a text form generated by a service". A form where - web page? How do you capture the string? Is it imported into a table? What is the field name?

Regarding your thread title - I don't see any asterisks.

Maybe like:

Mid([fieldname], InStr([fieldname],"http"), InStr([fieldname],",") - 2)