cut and pasting

[Chetgeo]

What i have done is converted an xls file. There r only a few fields, but the field i'm trying to do a makeover on is the phone #. I have converted the xls file over to FM and there r a couple of hundred files. I want to make a change using a script that will go into the field phone # grab the last four #'s and move them into a new field i have created. Is this possible?? I can use AUTOIT scripting, but i would rather do it in filemaker.

Thanx for any and all Help!

[danjacoby]

Use the RIGHT function -- it grabs characters from the right end of a field. In this case, you'll want to grab 4 characters.

[Chetgeo]

Works like a champ!