Creating custom dimension based on part of a string

[Alexander_Arozi]

Hi

I want to create custom dimensions based on the naming convention fo our imported marketing data.

If I for example have the dimension “campaign” on our table, that has the values of our marketing campaigns with a naming of “c:campaignname | b:brand | m:market | sc:source” from which I want to create 4 different dimensions, campaignname, brand, market and source.

essentially I want for the campaignname dimensions to be “everything after c: to the next |”

How would i best go about doing this?

regards
Alex