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=ACTIVE,name=Sprint 7,goal=,

 

Output should look something like,

Sprint 5, Sprint 6, Sprint 7

 

Is this achiveable ?

 

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

2 Replies

  • jbwtp's avatar
    jbwtp
    Icon for Memorable Member rankMemorable 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

  • DBA_BI's avatar
    DBA_BI
    Regular Visitor
    4 years ago

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