Forum Discussion

shuhn1229's avatar
shuhn1229
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's avatar
    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's avatar
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

  • shuhn1229's avatar
    shuhn1229
    Resolver I
    3 years ago

    looks like it's working great! you the man (or woman!)

  • lpetty421's avatar
    lpetty421
    Advocate I
    2 years ago

    Excellent!!!!!

  • lpetty421's avatar
    lpetty421
    Advocate I
    2 years ago

    Thanks John!!!!  Yours was the best answer of all!!!!!