RegEx extract numbers before and after text string

[EJ_Alt]

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 ID	ID 1	ID2	ID3
1234D983.22	1234	D	983.22
12N4445.56	12	N	4445.56
4Z33.33	4	Z	33.33

Thanks

[IraWatt · Accepted solution]

Hey @EJ_Alt,

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%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs]

@EJ_Alt Another way of doing this

[Alteryx_AR]

@EJ_Alt 

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

[EJ_Alt]

Thanks!

[EJ_Alt]

Thanks! works too.