Emabrased Newbie need help setting variables from .csv

[ppi]

After spending the last 2 hours trying to find the answer via the search function, I am posting this request for help. I’m sure this is somewhere on the forum, but I can’t fine it.

My problem. I have an excell spreadsheet via googles spreadsheet app. The doc has 5 colums with the titles:
Title Price Location Description Picture

I exported that to a csv file on my local hard drive with the path: Users:admin:Documents:Local.csv

What I am trying to do is create 5 separate variables with applescript that i’m going to pass into quickeys. I know how to set-up and pass a variable when there is only one variable in the document. Ex:

set City to read file “Users:admin:Documents:AllCities.csv” using delimiter “,”
set value of variable named “AllCities” to City as list
set value of variable named “NumberCities” to count of City

but this different csv has 5 different variables in it: Title, Price, Location, Description, Picture

Any help would be very appreciated. Thanks.

Banned because:

Membership in this forum requires that the webmaster know your real name and email address.

An AppleScript application can be written to do really evil things to the machine running it. We simply can not and will not allow members to upload scripts to our servers or to link to binaries of scripts on external servers if we don’t know exactly who the author is. In fact, there is legislation in force and some pending legislation (HIPAA, FACTA and Gramm-Leach-Bliley {GBL}) that apply to MacScripter, LLC, so we must be cautious.

Rather than trying to hide your name, you are encouraged to use a non-revealing user name and that is all visitors to ScriptBuilders will ever see. Your real name is never available to the public {or sold to others}, nor is your true email address exposed. If a user wishes to contact you directly they can do so from the links on the scripts info page.