Regex – Parse one column with different values delimited by a comma

[filiptoporek]

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.

[TimN · Accepted solution]

Here's an attempt.

Tim 

[Qiu · Accepted solution]

@filiptoporek 
We can use two Text to Column tools like below

[PanPP]

The attached workflow uses text to columns, but you can use regex if you prefer.

[flying008]

Hi, @filiptoporek 

If you want use RegEx function to get :

[ShankerV]

Hi @filiptoporek 

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

[filiptoporek]

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