[RESOLVED] Multiple Replace Function Order

[RosieP]

I want to do a multiple replace on one field in a table. I want to replace apos; and ampapos;. What would the order have to be to first replace ampapos;?

Do I do replace(replace(description, 'apos;', ''''),'ampapos;', '''') or
replace(replace(description, 'ampapos;', ''''),'apos;', '''')

thank you.

[leinad31]

replace the longer word first so you are not left with unreplaced 'amp' tokens.

[RosieP]

Thank you. What would the replace statement look like in order to replace those first?

[leinad31]

Try your second line of code in post #1

[RosieP]

thank you.