Re: truncating items in a list
Re: truncating items in a list
- Subject: Re: truncating items in a list
- From: "Mark J. Reed" <email@hidden>
- Date: Tue, 11 Dec 2007 12:30:16 -0500
On Dec 11, 2007 10:23 AM, Justin Laden <
email@hidden> wrote:
No problem. Here's my process:
First, I open a text file into Excel.
Then I copy the values in one column into a range.
It seems like you could set the format of that column so that Excel parses and reformats that date however you want, rather than bringing AppleScript into the mix. But if that's how you want to go, you can use a repeat loop plus Michelle's code - something like this:
: copy the value of range ("G1:G" & z) to dateRange
set outRange to {}
repeat with eachItem in dateRange
set end of outRange to short date string of (eachItem as date)
end repeat
copy outRange to range ("G1:G" & z)
--
Mark J. Reed <
email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden