Re: Newbie blues (was Remove spaces)
Re: Newbie blues (was Remove spaces)
- Subject: Re: Newbie blues (was Remove spaces)
- From: Malcolm Fitzgerald <email@hidden>
- Date: Thu, 3 Jul 2003 22:23:43 +1000
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:
Of course, this begs the question of why bother to use TE+ at all and not
just do it all in Filemaker:
tell application "FileMaker Pro"
tell every record
set cell "phone number" to my stripSpaces(it's cell "phone number")
end tell
end tell
You don't even need applescript. Do it with FMPs own tools.
1. put cursor in the field to operate on
2. Use the menu Records->Replace Contents
3. Replace using calculation: TextToNum(phone number)
--
--
Malcolm Fitzgerald email@hidden
Database Manager
http://www.asauthors.org
The Australian Society of Authors ph: 02 93180877 fax: 02 93180530
_______________________________________________
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.