Forum Discussion

Resolver I

3 years ago

Solved

Extracting From A Field with Multiple Delimiters

Hi all, I am relatively new to power query and am trying to extract all the text between [] delimiters in a field, if they exist. See example below: Input Output [Apples] - 46 [Oranges...

Need Help

jbwtp

3 years ago

Hi shuhn1229,

This may help:

Table.AddColumn(#"Changed Type", "Calculated", each Text.Combine(List.Transform(List.Select(Text.Split([Input], "["), each Text.Contains(_, "]")), each Text.BeforeDelimiter(_, "]")), ", "))

Cheers,

John

jbwtp

Memorable Member

3 years ago

Hi shuhn1229,

This may help:

Table.AddColumn(#"Changed Type", "Calculated", each Text.Combine(List.Transform(List.Select(Text.Split([Input], "["), each Text.Contains(_, "]")), each Text.BeforeDelimiter(_, "]")), ", "))

Cheers,

John