17673_en-US

liliconcom

Use Regex() to strip-off quoted text<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hi there,

I have field entries of the following build:

=HYPERLINK("https://fieldagent.co.uk/client/lightbox/?public_id=20639c06-a6ed-5a4f-9436-d9cf9e41adf8&mt=7&g=329914&q=82203", "Photo")

I want to strip-off everything around the first pair of quotation marks and just keep the URL reference:

https://fieldagent.co.uk/client/lightbox/?public_id=20639c06-a6ed-5a4f-9436-d9cf9e41adf8&mt=7&g=329914&q=82203

I found that the following is the correct Regular Expression to do this:

((?