Hello I want to know if how can I parse this using regex tool? I only want to extract the digits in the middle.
Can you help me with this one please?
@dunkindonut7777 We can use RegEx to parse the data.I use the web site below to build and test my RegEx.
https://regex101.com/
@dunkindonut7777 How do you define the "Middle"?
After 3 Periods "."?
Yes
Hi @dunkindonut7777 ,
If that is the case, I think you can do it without RegEx.
Formula Tool
1. replace "." to whitespace.
Output = Replace([Number Code], ".", " ")
2. Count the words, find the "middle" position, and get the word at the position.
Output = GetWord([Output], FLOOR(CountWords([Output]) / 2))
I hope this works.
Hi, @dunkindonut7777
Just like @Yoshiro_Fujimori said:
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?
