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

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

Workflow

Datasets

Regex

Tips and Tricks

Accepted answers

please try this regular expression:

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

it might help you.

cheers,

mark

All comments

please try this regular expression:

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

it might help you.

cheers,

mark

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

I've attached a sample workflow if it helps.

Thanks

Alteryx PO Search.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703