Forum Discussion
Parsing out text in a column in multiple columns
Hi Anonymous ,
It's very simple, here's the solution.
1.Right-click in the Error Description column and select Split Column By Delimiter.
2.Select custom, enter "---INPUT ERROR---".
3.After completing the split, you only need to delete the unnecessary columns and rename the column names.
Check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It's very simple, here's the solution.
1.Right-click in the Error Description column and select Split Column By Delimiter.
2.Select custom, enter "---INPUT ERROR---".
3.After completing the split, you only need to delete the unnecessary columns and rename the column names.
Check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for the help. I'm thinking with this solution, I'll need to pivot the data set to make reporting a little easier.