Extract String depending on characters before/after

HenpetsGordres1

Based on the following, XML is output for each row (record)

The first record will appear somewhat like the below image. Is there a way to extract the text in red below? The position of this text will change from record to record. I tried formula getWord but the string is considered 1 word, Trim also won't work due to the positon change mentioned previously.

Output

Accepted answers

Jonathan-Sherman

You could use a regex tool for parsing with a formula of:

.*?<name>(.*?)<\\name>

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200115 - ExtractString.yxmd

All comments

Jonathan-Sherman

You could use a regex tool for parsing with a formula of:

.*?<name>(.*?)<\\name>

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200115 - ExtractString.yxmd

HenpetsGordres1

Great thanks, not sure if it matters but I changed from '\\name' to '/name' and it works exactly as needed.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703