Re: Trouble with Lists in Excel
Re: Trouble with Lists in Excel
- Subject: Re: Trouble with Lists in Excel
- From: Kurt Klamp <email@hidden>
- Date: Tue, 8 Jan 2008 18:52:15 +0100
My Goal is to capture the first five characters of an item in a list.
The list was created by copying the values of a column into a
variable. I want to take the first five values, (only if they are
numbers, or with a first character of a letter) and copy them into a
new list, then copy this list into a different excel column.
The code:
copy the value of range ("D1:D" & z) to descriptionRange
repeat with i from q to (descriptionRange)
Maybe the loop as
repeat with i from 1 to (count descriptionRange)
will be better.
copy text "^[a-zA-Z][0-9]{4}" in item i of descriptionRange with
regexp to item i of jobNumRange
what command do you use here?
end repeat
set value of range ("A1:A" & z) to jobNumRange
Kurt
_______________________________________________
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