need a little help with a match

[rocket976 62]

Trying to find phone number inside square brackets and quotes.. but not having a lot of luck..

["(212) 733-1300"]

 

tried all manner of combos but not working for me..

[k1lv9h 76]

Hi,

 

Using your sample this code:

set(#pninput, "[\"(212) 733-1300\"]", "Global")
set(#pn, $replace($find regular expression(#pninput, "(\\d\{3,4\})"), $new line, $nothing), "Global")

would give you 2127331300

 

Kevin

[rocket976 62]

Thanks for the reply Kev, that sort of works but I guess I should have been more clear. I scraped the page and save the results to a variable from that variable Im pulling the address etc. BUT no dice on phone number..

 

Using this

 

using your code it gives a ton of numbers in no order.
 

variable data looks like this mess: (wont let me post it)

 

[Steve 30]

try this one:

set(#inputdata, "[\"(212) 733-1300\"]", "Global")
set(#phone, $find regular expression(#inputdata, "(?<=\\[\\\").+(?=\\\"\\])"), "Global")

[rocket976 62]

Works but pulls way too much data, now that I know the syntax for the brackets should be good to figure this one out. Thanks for your help.

[Steve 30]

Works but pulls way too much data, now that I know the syntax for the brackets should be good to figure this one out. Thanks for your help.

 

No prob. Good luck.