Extract specific information from a string

[hash_89]

Hi,

I need to extract specific information from a string that is of different length and not in the same order.

11507=15644¥11517;TFH¥11524;1¥11527;315¥11528;2023-02-01¥11529;2023-02-01¥11532;2023-03-14¥11534;7511¥11535;305

I would need to get the value after ¥11527; but before ¥

End result needs to be 315

Can someone help how to do it?

thanks

[smoosh]

See attached workflow for an example of what you need using RegEx. 

A couple of things, I'm not the greatest with RegEx, but the workflow does correctly grab the 315 you are looking for. As long as the data you need is between the '¥11527;' and the next  '¥' this should work though.

Try this site for more info on RegEx and what it's doing. 

https://regex101.com/

Good luck.

[alisonpitt]

I think this question might be a dupe of this one? Anyway, I think regex parse with ¥11527;(.*?)¥ should get you what you need 😊