Hi Team,
Hope you are well.
I need help. The below text1 to be split two columns.
Please find attached and let me know how to go about this,
Thanks,
Sri
Solved! Go to Solution.
A way of doing this would be to use the RegEx Tool.
Select 'Parse' in the Output box.
Column to parse - column name.
Format to convert:
several options
1. ([a-z]+\s[a-z]+-[a-z]+)-(\d{6})
broken down into English () brackets denote a part of the string that you want in a new column.
[a-z] is any lowercase letter, + is one or more of what precedes it, in this case a-z's,
\s is a single whitespace,
- is literal, that is, the hyphen, after this is the closed bracket for the end of the first column you require.
the hyphen outside the bracket is the second hyphen and is not returned as a column as it's not in brackets.
The 2nd column to return is \d which denotes any digit, followed by {6}. The brace bracket is specifying how many, in this case, 6. If the number of digits vary then \d+ should be used.
RegEx is well worth learning.
Use https://regex.com to test what result you will get when learning or experimenting for use in a workflow.
Hi @ShankerV ,
Thanks for your help. Really appreciate that.
Is it possible to split the same text into three columns.
Please let meknow,
Cheers,
Sri