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.

[Jonathan-Sherman · Accepted solution]

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

[HenpetsGordres1]

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

[Jonathan-Sherman]

No that's absolutely file @HenpetsGordres1, I must have mistyped my input! Just a piece of advice, if you can post the piece of text we can use for the input rather than a picture it makes it much easier to get you a solution as we can simply copy and paste into Alteryx rather than typing it up.