January 31, 200323 yr 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!
January 31, 200323 yr Use the RIGHT function -- it grabs characters from the right end of a field. In this case, you'll want to grab 4 characters.
Create an account or sign in to comment