Hi Community,
May i know how can i split the data below to the result as per screenshot below ?
Hi @SH_94,
I have created a solution for you:
The first column is created by keeping only digits and the second one removes digits and the first space.
The output:
I am bad with Regex but let me try 🙂
\ this sign is an escape character. Some of the letters have special functions like d is digit but for the computer to know that you need to use escape character first. If you will not do that he will not interpret your actions correctly.
\d - is information for computer that it is a digit
+ sign is information that can occur once or more
\s this is space
Tokenize is text to columns
Case insensitive will not have any impact here are we don't use letters. My assumption is case insensitive is about big and small letters but as I said I am a beginner regarding the regex 😀
Hi @Emil_Kos ,
Thank you for the workflow provided. I would like to clarify with you on the following formula and appreciate if you can explain on how we can use the formula below easily.
1. \d+
2.\s
3. May i know what is the difference if we tick or not tick the case insensitive?
4. What is the tokenise mean in this case?Can you give example on how we use the parse function ?
