Substring help please

[forco02]

I have a field coming in to my flow in the format

xxxx yyyy [ aaaa bbbb]

xxxx yyyy could be any length and i want to throw away everything from [ onwards (including the [) how can I do this?

I can get rid of everything before with: 

substring(triggerBody()?['subject'],variables('IndexOfBrace'),variables('NewLength'))

Thanks,

Colin

[abm]

Hi @forco02 

Try this

first(split(last(split(triggerBody()?['subject'],'[')),']'))

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[abm]

Hi @forco02 

If the below reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks