Hello Community!
Looking for help with Regex expression.
I tried to figure out how to parse one column with three values delimited by a comma and mixed in each row.
Example:
Product | Description |
One | Measures:10/10/10, Material: Steel, Color: Black |
Two | Material: Steel, Measures:10/10/10, Color: Black |
Three | Color: Black, Measures:10/10/10, Material: Steel |
Four | Measures:10/10/10, Material: Steel, Color: Black |
Five | Material: Steel, Measures:10/10/10, Color: Black |
Six | Color: Black, Measures:10/10/10, Material: Steel |
Seven | Measures:10/10/10, Material: Steel, Color: Black |
Eight | Material: Steel, Measures:10/10/10, Color: Black |
Nine | Color: Black, Measures:10/10/10, Material: Steel |
Ten | Measures:10/10/10, Material: Steel, Color: Black |
What I want:
Product | Description | Measures | Material | Colour |
One | Measures:10/10/10, Material: Steel, Color: Black | 10/10/10 | Steel | Black |
Two | Material: Steel, Measures:10/10/10, Color: Black | 10/10/10 | Steel | Black |
Three | Color: Black, Measures:10/10/10, Material: Steel | 10/10/10 | Steel | Black |
Four | Measures:10/10/10, Material: Steel, Color: Black | 10/10/10 | Steel | Black |
Five | Material: Steel, Measures:10/10/10, Color: Black | 10/10/10 | Steel | Black |
Six | Color: Black, Measures:10/10/10, Material: Steel | 10/10/10 | Steel | Black |
Seven | Measures:10/10/10, Material: Steel, Color: Black | 10/10/10 | Steel | Black |
Eight | Material: Steel, Measures:10/10/10, Color: Black | 10/10/10 | Steel | Black |
Nine | Color: Black, Measures:10/10/10, Material: Steel | 10/10/10 | Steel | Black |
Ten | Measures:10/10/10, Material: Steel, Color: Black | 10/10/10 | Steel | Black |
If you need more information please let me know. Thanks a lot for any hints or solutions.
Solved! Go to Solution.
@filiptoporek
We can use two Text to Column tools like below
Please find one way of reaching the solution for your expected output.
Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!
Many thanks
Shanker V
Hello,
many thanks for all your response. All of your solutions are helpful and work properly.
In general, my real example is more complicated, but I used a solution written by @Qiu
Best regards,
Filip