Best and easier way to parse the text out of string within power query

[Anonymous]

Hi All,

What is the best and easiest way to parse this string into separate columns?

I have 10 columns in powerbi that contains this string and I want parse this into separate columns.

I know I can do it using delimitator but it will be alot of work to do for each column.

[{ShipToNumber:234}{ShippingAddress:234}{ShippingConditions:234}{INCOTERMS1:234}{INCOTERMS2:243}{ShippingInstructions:234}{Contacts:(234,234),(1234,213)}][{ShipToNumber:234}{ShippingAddress:1234}{ShippingConditions:123}{INCOTERMS1:123}{INCOTERMS2:123}{ShippingInstructions:1232}{Contacts:(234,234)}]

[ImkeF · Accepted solution]

Try unpivoting the 10 column and perform the operation on just the resulting Value-column.

Then consider if that shape isn't better suited for your data model then those 10 original columns. 
Otherwise pivot back.