Hello,
I am fairly new to the world of Filemaker and as a longtime lurker, this forum has already helped me immensely.
However, there is one issue that I am currently having for which I cannot seem to find a solution. Any tips would be well appreciated.
I have a large database of contacts with the phone numbers in the format 1234567890. I would like to insert hyphens so that the phone numbers appear as 123-456-7890.
There are over 50 000 records, so doing this manually is out of the question.
Can someone please point me in the right direction to writing a simple script that would automate this procedure?
Any help is greatly appreciated.
Thank You.
John
