Good morning,
Can you please tell me how I would structure multiple replaces in VIP?
I have a requirement to remove both single and double quote marks from a single field before they are placed in a SQL table.
Currently I am using the following which works fine for removing the single quote marks:
Replace("[PJINV]","'","")
How would I change this so that it looks at both possibilities on the same input field? (ie single quotes and double quotes)
Thanks
Joe
