Re: Newbie blues (was Remove spaces)
Re: Newbie blues (was Remove spaces)
- Subject: Re: Newbie blues (was Remove spaces)
- From: Bernard Azancot <email@hidden>
- Date: Sun, 29 Jun 2003 19:10:57 +0200
Le dimanche, 29 jun 2003, ` 18:08 Europe/Paris, Gary a icrit :
Bernard,
Given your recent more complete explanation of the context and purpose
for
your script, it seems much less work to just use FM's field validation
and
patterning.
FileMaker's field validation can very capably transform your
international
phone numbers to whatever other format you wish (include hyphens,
group with
parenthesis, etc.)
It may be much more efficient for you to open the field definition for
the
phone number field and set the validation options to the format you
desire.
This way, the persons entering data have the luxury of being able to
enter
the digits as they are usually written or printed (with spaces), while
your
output can compact or otherwise transform the digits.
Also, any data move increases the likelihood of introducing error. So,
an
export to a text editor, script transformation and importing adds
considerable opportunity for data loss and/or corruption.
--
Gary
Thanks Gary,
Yes, of course...
In fact your advice is exactly what I have done for all the phone
fields of this new FM base.
When the user enters the digits of a new phone number "## ## ## ## ##",
FMP changes it to "## ## ## ## ##".
Thus I need all the phone numbers to be formated as "## ## ## ## ##".
No problem with a new empty FM base.
Unfortunately the export file comes from a 4D base already containing
"## ## ## ## ##" formated phone numbers. I would like to "clean" it ,
i. e. transform all the already existing phone numbers in "##########"
format) before re-importing the modified file in a FM base.
Then, no more text editor manipulations.
If I import directly the "## ## ## ## ##" formated phone numbers, they
are going to be changed and become a mess.
The solution could be to write a FM replace script, but then I am never
going to improve my AS skill ;-)
Life is sometimes difficult ;-)
Yours
Bernard
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.