>This may sound stupid, but how do I actually go about doing these commands on the data. Can they just be typed in the command window if the table is open or do I have to write a program first and then run it.
>
>Thanks much,
>Ryan

Either way. You could add them to a program that imports the data. Or if you are importing using commands from the Command window then type them as well.

One other thing about the replaces. The default scope for a replace is the current record. If you want to replace all values in a table with these values just add the ALL keyword.

replace all myfield with transform(myfield, "@R 999-999-9999")