Hi makers,
I’m a newbie and have a question to use functions.
For example, I have a value below.
In this value I just want to get number (12345678),
But I cannot think any of ways to extract only numbers.
Could you please help this?
Hey @Yong_Yun,
This is a somewhat advanced, but you can do this using regex. Simply use the text parser ‘Match pattern’ action, and use the expression [+-]?(\d+(\.\d+)?|\.\d+)([eE][+-]?\d+)? for the pattern to match and select the text you’d like to extract the numbers from in the ‘text’ field.
Hope this was helpful!
Hi @NocodeNoah
That’s really helpful!
But I have another question…
It seems like this regex can extract all numbers in the value.
My next question is, what about this value?
In this value this regex works same?
Please help me. Thanks!
Hey @Yong_Yun,
Yes, that should also work! I would encourage you to try different situations and see if this expression suits your needs. If you want a extract something else from a text, you can try https://regex101.com/ or https://regex-generator.olafneumann.org/ to help you find the right expression for your needs.
