Applescript read CSV file
kr192-1600 SEK
Kulipwa wakati wa kujifungua
Write an Applescript that reads a CSV-file and extracts each column in csv-file and places the column in a variable with delimiters.
Mission:
1) A path needs to be specified to the csv-file that can handle different users logged in.
The file is located in "Users/username/Dropbox/[login to view URL]", however the username will be replaced depending on which user is logged on. All users have the same Dropbox setup, like below:
"Users/Adam/Dropbox/[login to view URL]"
"Users/Dennis/Dropbox/[login to view URL]"
2) The CSV file consists of n rows (MAX 1000 instances) and c columns (MAX 10 instances) that may increase/decrease. There is always data in each table-box in column 1 and row 1. But not always data in each table-box in column 2 and beyond. (See attached example csv)
3) First row contains headers and should be skipped.
4) Attached image shows example-input on left side and example output on right side. Please note that input is a csv-file. Output is just saving to variables locally. You may use a list for saving the columns.
Kitambulisho cha Mradi: #17131633