Re: Trouble with Lists in Excel
Re: Trouble with Lists in Excel
- Subject: Re: Trouble with Lists in Excel
- From: "Justin Laden" <email@hidden>
- Date: Tue, 8 Jan 2008 09:12:10 -0500
> Justin,
> I use an older version of Excel, so my scripts are generally different,
> however, looking at your script above, I assume you have Smile or
> Satimage OSAX. If so, your command copy text seems inappropriate.
> I believe you want to make changes to text, so make the changes. also
> set you item i to what you want it to be, do not copy to it.
>
> repeat with i from 1 to (descriptionRange)
> change "^[a-zA-Z][0-9]{4}" in contents of (item i of
> descriptionRange) into (whatever) in item i of descriptionRange with
> regexp to item i of jobNumRange
> end
>
> You are not asking excel, but satimage osax. Now check to see if
> change is a word in excel's dctionary. If it is, do this change
> outside the tell bloc.
>
> Show more of your script if you want help.
>
>
> Deivy
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)
copy text "^[a-zA-Z][0-9]{4}" in item i of descriptionRange with
regexp to item i of jobNumRange
end repeat
set value of range ("A1:A" & z) to jobNumRange
Thanks for all the help.
_______________________________________________
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