I have downloaded scv file from google forms.
UNfortunately broken and need correction before useable.
Tasks which i do manually but want to apply by script. (script and incorrect file in same folder; output in same folder)
1. REPLACE NEW DELIMITER CHARACTER THAT MIGHT BE IN TEXT: "§" by "+"
2. REPLACE delimiter character "," by "§"
3. Replace correct linebreaks "^p "###
4. Replace incorrect linebreaks ^p by space
5. Replace Space before semicolon with comma space; ->;
6. semicolon and space with comma and space space -> ,space
7. changeback correct linebreaks "### with "^p (linebreak)
note that ^p is the sign for linebreak in word. I am not sure what is the code for that when you apply on text file
The final file need to have every line starting with the timestamp
Sample of incorrect file is attached.
Pls start your bid which "can be done immnediately" to ignore generic bids.
20 freelancers are bidding on average $27 for this job
can be done immediately Hello, This is Prosenjit. I can write small PowerShell to achieve the goal. The prerequisite is: 1. PowerShell major version should be 5 Let's start to discuss further
It's an easy job, I'm an excel expert. Give me the opportunity and I won't disappoint you. Relevant Skills and Experience A lot of experience in excel.