We have a CSV file which has some fields that contains words that are all in uppercase. We would like to process the CSV file changing some of the entries to lower and uppercase, and leaving some as they are.
The first step would be to analyse 4 columns of the CSV file to determine a list of unique words. We would then decide which of these words become upper and lower case and which stay the same.
Once the list has been compiled, the words that we have requested to be changed should be changed and copy of the CSV file made available for download.
Here is an example:
In one field, we have:
BROTHER TN155 BLACK TONER HL4040 HL4050 HIGH YIELD
In this case the words we would like to change would be:
BROTHER, BLACK, TONER, HIGH, YIELD
They should be changed to:
Brother, Black, Toner, High, Yield
So the field content would now be:
Brother TN155 Black Toner HL4040 HL4050 High Yield
If any other field that contains BROTHER, BLACK, TONER, HIGH, YIELD should also be changed to lowercase.
Attached in an example of the CSV file that the columns that need analysing are D, E, F and I
We would like the system to learn the changes, so we could provide a list of words to change based on a list of unique words. Then if when another CSV file is uploaded for cleansing and there are new words added, the system should ask if they need to be changed or not and save the response for the next file upload.
Please ask any questions by PM.
Thanks for taking the time to read this post.
52 freelancers are bidding on average $180 for this job
Hi sir, This is kimi and I checked fill description, yes I can do this for you and can start right now. Thanks, Kimi Relevant Skills and Experience PHP MYSQL Proposed Milestones $155 AUD - full payment
I can do this program to clean csv, within 1 day. can we discuss. Thanks Relevant Skills and Experience php mysql Proposed Milestones $150 AUD - Initial Milestone
i seen your csv file, message me for discussion Relevant Skills and Experience php, wordpress Proposed Milestones $155 AUD - csv field updation by script
Hi I can write a small PHP script to convert the csv file as you wrote. I can be used for you later on new files. Habilidades y experiencia relevante PHP, Parsing Htos propuestos $100 AUD - Happy client