Applescript read CSV file

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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.

Applescript

Nº del proyecto: #17131633

Sobre el proyecto

1 propuesta Proyecto remoto Activo hace 5 años

Adjudicado a:

gangabass

I can provide you Applescript code that will read CSV file, parse it and transpose it just like you want (output will be variables for each column). But I have one small question: do you have complex CSV (I mean com Más

kr1600 SEK en 1 día
(1 comentario)
2.5