Hi All, I would appreciate some help with using a RegEx or suitable tool to do this. Essentially extract all digits before and after text Account IDID 1ID2ID31234D983.221234D983.2212N4445.5612N4445.564Z33.334Z33.33 Thanks

RegEx extract numbers before and after text string

Hi All,

I would appreciate some help with using a RegEx or suitable tool to do this. Essentially extract all digits before and after text

Thanks

Regex

Here is one way to do this with Regex

([\d\.]+)(\D+)([\d\.]+)

The first and third group captures one or more number characters or points '.':

([\d\.]+)

The second group captures any non number characters:

(\D+)

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Here is one way to do this with Regex

([\d\.]+)(\D+)([\d\.]+)

The first and third group captures one or more number characters or points '.':

([\d\.]+)

The second group captures any non number characters:

(\D+)

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

@EJ_Alt Another way of doing this

I used following expression to parse. Hope this helps you.

Thanks!

Thanks! works too.