Hi all, I have a list of data with sample like "<c r="A4" s="1" t="e"><f>- Of which: other</f><v>#NAME?</v></c>"
I need to extract the part "Of which: other" only. How to use regex for this purpose? It is fine if other tools to be used.
thanks.
Solved! Go to Solution.
Hi @flying008 , Thanks, but this expression does not work with the RegEx tool. I think it needs to be modified somewhat.
Hi @JokeFun
You could try the following:
*OOPS, I've left the "-" in the bracket. You can simply move this out , to the left of the bracket: <f>-(.*?)<\/f>
Hi @martinding , Thanks! This works. Just would like to know what does the \ mean in this part <\/f>? What if just put </f>
Hi @JokeFun,
The backslash "\" is known as an escape, and the forward slash is often a special character in RegEx.
In order for RegEx to process / literally, it needs to be escaped, so I included "\" just in case.
Now, I tried excluding "\" just now, and the code still seems to work as expected. There are many variations of RegEx and it seems that / is not taken as a special character in Alteryx.
Got it! Thanks for the reply. @martinding