I’m a newbie and have a question to use functions.
For example, I have a value below.
- 12345678 : This is a test value
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?
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!
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?
- Value : 12345678: This is 2 text value
Please help me. Thanks!
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.
Hey @NocodeNoah ,
That’s really helpful, Thanks a lot!