How to write script to replace charactar to another character?

[profilmgear]

Hi..

Does anyone know how to write a script to automatically replace all @ character with & character in a textfield data through all the records in my filemaker database?
I can so it manually but that are too much of it and feel difficult.

Thanks.

 

[JeanW]

Look what the Substitute function can do for you.

Make a loopingscript to go through the found set of records and substitute all the characters.