Scrivere alcuni Software
€30-250 EUR
Paid on delivery
Hi, my problem is simple. I have a csv on a ftp folder that continuosly is updated every 20 minutes because is exported from another source. In this csv one column contains some quantity information about my products, the fields in this column are fill in this way: " 1 1 2 1 1 1" there are spaces between one number and the other. I need a script that automatically substitutes spaces with a character like "x" or "z" (not important which character). Therefore the field will be "xxxxx1xx1xx2xxxxx1xx1xx1"
This script has to save the modified csv in the same folder fpt every 20 minutes.
I attached an example of csv you'll find on ftp folder "how it is" and one "how it would have to be", the column is called QtaGiaTg which is the column Y.
I hope to have been clear enough.
Project ID: #10519143