extract substring using compose

[Harry_G]

I have string have value "[113] this is testing string". i need to convert it "this is testing string". I tried compose action with substring using Indexof. But unfortunately it doesn't work for me. Any help woulf be appreciated 🙂

[v-yuazh-msft · Accepted solution]

Hi @Harry_G,

I have made a test on my side, please refer to screenshot below to create the flow:

The expression in the Compose 2 as below:

substring(outputs('Compose'),6,22)

And you could also enter the expression below in the Compose 2:

last(split(outputs('Compose'),'[113] '))

The flow would run successfully as below:

Best regards,

Alice

[Harry_G]

Thanks @v-yuazh-msft. it working like a charm :).

[kedarsk]

Thank you but you have manually mentioned the 6 and 22 as number for index and characters . How to get it automatically or in other words what if we aren't sure about what those numbers could be?

[stevenls]

How would you go about this if you wanted the values between << and >>

i.e.  <<just this text>>  would return  just this text

[PSchiager]

First(Split(Last(Split("<<just this text>>", "<<")), ">>")), which will first extract "just this text>>" and then "just this text".

[stevenls]

@PSchiager   nice thanks 🙂