Devam Ediyor

480657 Process CSV Files

I would like a Windows script to be able process CSV files. Attached are instructions and examples files.

1) Open working file (example: [url removed, login to view])

Each row contains a domain name (column A) and the name of a csv file (column B) corresponding to that domain name.

2) Go through each row of this file, open the corresponding csv file in colum B. (example: for row 1, open [url removed, login to view])

The csv file to be processed has a blank column A and column B with a key word phrase per row.

3) For the csv file (example: [url removed, login to view]), go through each row and do the following:

- take the domain name (from working file) and append the keyword phrase (column B) and then append ".html" to it, then replace all spaces with "-" (dash)

- Example: Row1: [url removed, login to view]

- insert this for that row in the blank column A

- repeat with each row until the end of csv file

4) Save the file (now with column A filled in) - Note save with same name (don't save as separately named file)

See "[url removed, login to view]" for example of finished processed csv file.

5) Open file "[url removed, login to view]" and append the data from the processed file. Note, this file will keep getting longer as you append the dafa from each processed csv file (see example file "[url removed, login to view]")

6) Repeat for each row in working file ([url removed, login to view]) until the end.

In the end, all the CSV files will have column A filled in and you will have long CSV file containing all the data from all the CSV files that were processed.

Beceriler: Her şey Kabul

Daha fazlasını görün: attached files, row b, word csv, replace files, csv insert keyword, keyword csv files, csv data process, file csv, file open process, list open files, csv file html script, open files process, process open file, windows process, csv windows, working data csv files, script list files, process csv file, open html file word, keyword replace script, insert data word, file process, data csv html, csv list, csv column

İşveren Hakkında:
( 8 değerlendirme )

Proje NO: #2226567

Seçilen:

kulepseu

Software is ready

0 gün içinde 30$ USD
(0 Değerlendirme)
0.0