Find fist 10 numerical characters within string starting with '300'

[ALT_2358]

I have a field that concatenates all the other fields in a dataset.

Within this field, there are 10-digit codes all starting with '300' which I need to extract. I came up with one solution which works except on rows containing other numbers starting with 300, e.g. £3000. It would only work if the 10 digit code appears before the unwanted number.

Is there a way to do this?

Thanks

[MarqueeCrew · Accepted solution]

@ALT_2358 ,

 please try this regular expression:

Regex_Replace([text],".*?(300\d{7}).*",'$1')

it might help you. 

cheers,

 mark

[ALT_2358]

Thanks for the quick reply. 

This is my first time using the RegEx tool so I'm probably just doing something wrong, but I'm struggling to get the right output using this formula. 

I've tried selecting all the different output methods (parse, match, etc.) but I'm either getting no output, nulls or 'False' on every line. 

Thanks

[ALT_2358]

I've attached a sample workflow  if it helps. 

Thanks

[deviseetharaman]

Hi @ALT_2358 

@MarqueeCrewgave the regex expression inside the regex_replace() function. This you can use with Formula tool. If you want to use Regex Parse tool, then give only the regex expression - .*?(300\d{7}).*

[ALT_2358]

Amazing! That worked perfectly, thank you both so much!!!

Looks like I have a lot to learn haha!