Devam Ediyor

474819 Bulk Processing of CSV Files

This should be an easy project. The goal is to do some simple processing to a batch of CSV files:

For each CSV file in specified directory:

(Example, for a file named: [url removed, login to view])

Delete all columns except FIRST COLUMN

Delete ROW 1 of remaining column

Remove all double quote marks and all open and close bracket symbols: " [ ]

Remove all dashes and ".csv" from file name to get keyword phrase to search for ([url removed, login to view] -> custom wine glasses)

Search for that keyword phrase in the remaining column in the csv file:

- if found, move it up to ROW 1 (making sure to delete that empty row)

- if not found, add it to ROW 1 (i.e. insert row at beginning and add the keyword phrase)

Save the file into a specified folder (a subfolder in current directory)

Repeat with rest of CSV files in directory

This can be done in Windows or on a server (PHP or whatever).

See attached CSV files for example.

Beceriler: Her şey Kabul, PHP, Windows Masaüstü

Daha fazlasını görün: attached files, simple csv, search for files, processing, get files, bulk processing, bulk file, bracket, batch file name, csv files processing, csv quote, bulk insert, csv insert keyword, keyword csv files, wine csv, delete files folder, wine search, processing csv, processing csv files, simple project insert php, php delete files directory, insert folder, easy search directory php, rest php insert, batch windows

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

Proje NO: #2220724

Seçilen:

kulepseu

== Ready to start ==

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