Extarct repetitive text from the long string with delimeters

[DBA_BI]

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 ?

[jbwtp · Accepted solution]

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 · Accepted solution]

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

[jbwtp · Accepted solution]

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