Help on Regex

[JokeFun]

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.

[flying008]

Hi, @JokeFun 

(?<=\<f>-).+?(?=<\/f>\<v>)

[JokeFun]

Hi @flying008 , Thanks, but this expression does not work with the RegEx tool. I think it needs to be modified somewhat.

[martinding · Accepted solution]

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>

[JokeFun]

Hi @martinding , Thanks! This works. Just would like to know what does the \ mean in this part <\/f>? What if just put </f>

[martinding]

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.

[JokeFun]

Got it! Thanks for the reply. @martinding