• 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: Problem with "unavailable" values...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem with "unavailable" values...


  • Subject: Re: Problem with "unavailable" values...
  • From: Emmanuel <email@hidden>
  • Date: Fri, 23 Sep 2005 18:08:56 +0200

At 11:53 AM -0400 9/23/05, Michael Heinz wrote:
I'm trying to write an applescript to extract records from an appleworks database and write them out as a CSV.

The problem is that empty fields are frequently being written out with some variation of <<somerandomstuff...UnAv>>. No matter what I try, I can't seem to identify those fields to change them to a sane value before printing. I tried "if field = missing value" but it didn't seem to work.

Maybe you could find some operation which triggers an error for those empty fields. Such as:


set x to length of theContents

Then you could use the "try ... on error" structure to identify the empty fields.

try
	get length of theFieldContents
	 -- no error, field ok
	dowhateverimpliedbyfieldok()
on error
	 -- error: field empty
	dowhateverimpliedbyfieldempty()
end

Emmanuel
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Problem with "unavailable" values... (From: Michael Heinz <email@hidden>)

  • Prev by Date: Problem with "unavailable" values...
  • Next by Date: Re: Using terms from syntax
  • Previous by thread: Problem with "unavailable" values...
  • Next by thread: Re: Drilling down into an AppleScript object reference
  • Index(es):
    • Date
    • Thread