MACSCRPT Archives

November 2009

MACSCRPT@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Bill Steele <[log in to unmask]>
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Wed, 18 Nov 2009 11:15:09 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (22 lines)
I have an Excel spreadsheet with e-mail addresses: column A is the 
user, column B is the domain. I need to concatenate them. Problem 
arises when I hit a compuserve address:

		set addLeft to value of cell 1 of row i of used range 
of active sheet
		set addRight to value of cell 2 of row i of used 
range of active sheet
	display dialog addLeft  --> 12345.6789
	display dialog (addLeft & "@"  & addRight) as string  --> 
[log in to unmask]

Applescript treats the number as floating point when converting it to 
a string???

The column in Excel is formatted as string.

-- 

Bill Steele
[log in to unmask]

ATOM RSS1 RSS2