Recent content by bennylynch

Thanks for all the replies, the nested Replace worked with a small tweak, Thank you.

Thanks for all your replies,great forum. FAO: DALeffler, I think your nested Replace might be what I am looking for, I'll let you know, cheers everyone

Hi, i am looking to replace characters in a field using a query, I can use the replace to replace them all but that aint what I want e.g. I want this: ~~test~test~~~~~test~~ To become this: test~test~test I can use replace and get this testtesttest, but I need the ~ placed back between each...