>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")
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao