I have some records
Id | Owner Name | Phone 1 | |
1 | A | 9965\7654\8743 |
How to convert into
Id | Owner Name | Phone1 | Phone2 | Phone3 |
1 | A | 9965 | 7654 | 8743 |
Use Text to column tool
in delimiter add \
your data will split into 3 parts
agree with @BRRLL99 see workflow attach for more help
Hi @tarun_kumar10 try it like this sample
Thanks
There are a few different ways to parse delimited string data into multiple columns. The Text To Columns tool is probably the most common due to its similarity to the Excel functionality.
I have attached a workflow demonstrating 6 examples of getting to the same result. Hopefully this demonstrates there are multiple ways to get to the same solution, and helps to show people different functionality they may not have seen before.
I have used the Text To Columns, Text To Columns (Rows mode), RegEx (Parse), RegEx (Tokenize), RegEx (Tokenize (Rows mode)) and Formula tools. See the workflow for details on how to configure for the desired output.