Re: Newbie blues (was Remove spaces)
Re: Newbie blues (was Remove spaces)
- Subject: Re: Newbie blues (was Remove spaces)
- From: Gary Lists <email@hidden>
- Date: Sun, 29 Jun 2003 12:06:18 -0400
On or about 6/29/03 9:50 AM, Bernard Azancot wrote:
>
Le samedi, 28 jun 2003, ` 19:09 Europe/Paris,
>
email@hidden a icrit :
>
>
Thanks a lot to Kai and Christopher Stone.
>
>
>> Removing the spaces, would be my nExt aim.
>
>
>
> That's what it does - but only in AppleScript. I imagine you really
>
> want to
>
> do something similar in Tex-Edit Plus (although I'm not entirely sure
>
> what
>
> your aim is).
>
>
Yes, that's it.
>
>
More details:
>
Open a Filemaker export tab-return file with TE+.
>
Search all the (french) phone numbers appearing as "xx xx xx xx".
>
Change them to "xxxxxxxx"
>
Re-import the file to FM.
>
>
Text sample:
>
=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
Blablah Blablah Blablah Blablah Blablah 12 34 56 78 78
>
Blablah Blablah Blablah Blablah Blablah Blablah Blablah Blablah
12 34
>
56 78 78
>
Blablah Blablah Blablah Blablah Blablah 12 34 56 78 78
>
>
To change to:
>
=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
>
Blablah Blablah Blablah Blablah Blablah 1234567878
>
Blablah Blablah Blablah Blablah Blablah Blablah Blablah
>
Blablah 1234567878
>
Blablah Blablah Blablah Blablah Blablah 1234567878
>
>
=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
Note:
>
It would be easy to make it in Filemaker, but I prefer to make it
>
"externally".
>
>
Kai's and Christopher Stone's solutions are not able to do the work. I
>
may have missed something.
>
>
This list is very useful.
>
Thanks again.
>
Bernard
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
_______________________________________________
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.