Split colum by tekst

Hi bgroenhuijzen ,

you can try this for the text before the delimiter:

Table.AddColumn(#"Changed Type", "Text Before Delimiter", each Text.BeforeDelimiter([Voorbeeld], " bij"), type text)

And this for the text after the delimiter:

= Table.AddColumn(#"Inserted Text Before Delimiter", "Custom", each let splitVoorbeeld = Splitter.SplitTextByDelimiter(" opdrachtgever ", QuoteStyle.None)([Voorbeeld]) in Text.Combine({Text.Start(splitVoorbeeld{1}?, 15), Text.Reverse(Text.Middle(Text.Reverse([Voorbeeld]), 35, 1))}), type text)

With "voorbeeld" as the column name I used to create the rule on.

If you ever find yourself in a similar situation again, you can use the "add column from examples" functionality. This allows you to type in the value you want to end up with in a new column. Based on the values entered, you will get a suggestion on how this could be done in power BI:

Just enter that string as a custom delimiter in the Split Column dialogue: