Hi Community,
May i know how can i split the data below to the result as per screenshot below ?
Solved! Go to Solution.
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:
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 ?
Hi @SH_94,
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 a lot for the sharing. It really helps a lot to me as i don't know how to use REGEX.
Appreciate it.
Hi @Emil_Kos ,
I just tried the workflow that you provided and would like to ask how about if i want to split the text below
1. CDG0 (column 1) Result = CDG (column 1) and 0(column 2)
2. AEG0 (column 1) Result = AEG (column 1) and 0(column 2)
How should i build the workflow in this case?
Thank you for your help.
Hi @SH_94,
Please see the workflow attached.
One is using regex second one is using a data cleansing tool. Both of them will work for you.