Help with special characters in a string.

[stephenJames]

Hello 

        I need some help with how to format my expression to be able to use special characters. As currently it is breaking the flow.

My current expression is as follows

trim(substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Requestor's Agency'),46),sub(lastIndexOf(body('Html_to_text'),'* Agency Approver Title'),add(indexOf(body('Html_to_text'),'Requestor's Agency'),46))))

Unfortunatly because the word " Requestor's " has a ' in it, it breaks the expression and i get failure in flow. 

Can someone explain how this needs to be formatted to work.

Thanks

[FoDelement · Accepted solution]

Hello @stephenJames ,

Flow uses ' to define different strings.

Try this

'Requestor''s Agency'

[stephenJames]

---

@FoDelement wrote:

Hello @stephenJames ,

Flow uses ' to define different strings.

Try this

'Requestor''s Agency'

---

Thanks @FoDelement  that worked perfectly