Forum Discussion

DBA_BI's avatar
DBA_BI
Regular Visitor
4 years ago
Solved

Extarct repetitive text from the long string with delimeters

Hello,   I have a column as below and i would like to extract the text thats under 'name='       [id=1254,state=CLOSED,name=Sprint 5,[id=1342,state=ACTIVE,name=Sprint 6,[id=1234,state=A...
Need Help
  • jbwtp's avatar
    jbwtp
    4 years ago

    Hi DBA_BI,

     

    Try this one:

    = Text.Combine(List.Transform(List.Skip(Text.Split(Source, "name=")), each Text.BeforeDelimiter(_, ",")), ", ")

     

    Source is your string.

     

    Kind regards,

    John

  • DBA_BI's avatar
    DBA_BI
    4 years ago

    Thanks so much John, worked like Magic !!!!

jbwtp's avatar
jbwtp
Memorable Member
4 years ago

Hi DBA_BI,

 

Try this one:

= Text.Combine(List.Transform(List.Skip(Text.Split(Source, "name=")), each Text.BeforeDelimiter(_, ",")), ", ")

 

Source is your string.

 

Kind regards,

John