Delimited data

[tarun_kumar10]

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

[BRRLL99]

Use Text to column tool
in delimiter add \
your data will split into 3 parts

[aatalai]

agree with @BRRLL99 see workflow attach for more help

[Sarreddy]

Hi @tarun_kumar10 try it like this sample

[tarun_kumar10]

Thanks 

[mark-spain]

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.