Hello I want to know if how can I parse this using regex tool? I only want to extract the digits in the middle. Number CodeExpected Output10.10.000.111225.000.000.00111225 Can you help me with this one please?

PARSING DATA

Hello I want to know if how can I parse this using regex tool? I only want to extract the digits in the middle.

Number Code	Expected Output
10.10.000.111225.000.000.00	111225

Can you help me with this one please?

Adobe

@dunkindonut7777
We can use RegEx to parse the data.
I use the web site below to build and test my RegEx.

@dunkindonut7777
How do you define the "Middle"?

After 3 Periods "."?

Yes

@dunkindonut7777
We can use RegEx to parse the data.
I use the web site below to build and test my RegEx.

GetWord(Replace([Txt], '.', ' '), FLOOR(CountWords(Replace([Txt], '.', ' '))/2))

Hello Thank you for this. How about this one.

I only want to extract the first 6 digits, without touching the other value in column. Can you helm me with this one?

@dunkindonut7777
I would use the RegEx_Match function as below.

hello can you provide the alteryx file or the formula so that I can copy paste and edit?