shell or php script editing excel csv file under centos
$30-100 USD
Dalam Kemajuan
Disiarkan lebih dari 10 tahun yang lalu
$30-100 USD
Dibayar semasa penghantaran
i have excel csv file downloaded from vendor every day in my centos server
see attached file
there are total 15 columns
i need some script do following job
1. if any key column value is missing, then delete that row(SKU, Catergory,Subcategory,LargeImage,Title,QtyAvailable,Description,netWeight,[login to view URL],UPC)
2. merge column C & D example, C2 value =Audio & Bluetooth, D2 value=Audio Adaptors, then make value "Audio & Bluetooth/Audio Adaptors"
3. if Make value=empty, put 'xxxxxx'
4. after making above job, rename it [login to view URL] (be noted this csv file downloaded everyday with same name via cron)
5. do compare SKU column and make a csv file, '[login to view URL]' (if sku was gone).
6. file encoding is UTF-8 and can't not be changed
7. keep [login to view URL] and [login to view URL] for seven days
8. under same directory , two modified csv file, and seven day dated files should be there , total 16 files.