>my text file arrives in the following format: 7045014839271,
>
>i need it to import into a table in the following format: 9999-99-999-9999.
>
>any ideas anyone?
Are you talking data? If so then the TRANSFORM function should help you.
? TRANSFORM('7045014839271','@R 9999-99-999-9999')
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers