Replace/Delete multiple parts of a string in formula

Question

Hello everyone, I have a column of strings looking like this:

This is the text.

Is it possible for me to get rid of "

" and "

" using one formula? Can I use Regex? Thank you so much for your help.

Bahouth12 · Accepted Answer

Hello wenjuanchen, One possible way to take out

and

and keep the text in between them using formula tool is like this: Spoiler REGEX_Replace([YourField], '(\s<.*?>)|(<.*?>\s)','')

Surendar28 · Accepted Answer

Hello Wenjuanchen,

You can use XML parse

Thanks

Surendar

tom_montpool · Accepted Answer

You can 'nest' formula functions: Replace(Replace([YourField],"

",""),"

","")