• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Newbie blues (was Remove spaces)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

References: 
 >Re: Newbie blues (was Remove spaces) (From: Andrew Oliver <email@hidden>)

  • Prev by Date: why won't force-eject work in a script, but will from command line?
  • Next by Date: Dialog boxes in Photoshop
  • Previous by thread: Re: Newbie blues (was Remove spaces)
  • Next by thread: Re: Newbie blues (was Remove spaces)
  • Index(es):
    • Date
    • Thread