Hi All,
I have a dataset in which "Order number" contains multiple orders separated by delimiter (//).the number of orders concatenated within "order number" column can vary from 1 to 99. I want to split based on the delimiter irrespective of the number of "orders" contained to the original column. It can be done by "Text to Column" tool but there are many issues with that. Is there a way i can use RegEx or any other tool?
I have attached a sample data set to it.
Thank you!
Solved! Go to Solution.
@ArnabSengupta
Text to Columns and RegEx should do it.
@ArnabSengupta
Thank you for the mark!