October 30, 200322 yr Newbies I am a first time user of a Filemaker 3.0 Pro and I have a database that has Names, Addresses, & Phone Numbers in a list. The problem is that the Phone Numbers are a straight 10 digits (without the hyphens). I need to reformat the field to include the hyphens. There are approximately 3400 entries on this list. Too many to add 1 at a time. Is there a way to add the hyphens to the numbers all at once. I am using Windows 98 and am a relative novice to computers, but do possess some very basic skills.
October 30, 200322 yr Put the field on a layout, put your cursor in it, then go to Records->Replace and select 'Replace with calculated result'. Paste this calc into the Specify dialog and substitute phone with your field name: Left( phone, 3 ) & "-" & Middle( phone, 4, 3 ) & "-" & Right( phone, 4 )
Create an account or sign in to comment