Forum Discussion
Convert Text to Columns Wizard
Thank you for your response. I don't know more than the very basic functions of Excel. Each morning I receive an email with a CSV file attached (Maintenance 1M3D2020_DailyCoolingLog.CSV). I have managed to figure out how to use the convert text to columns wizard to end up with the CSV file (A TEST 1M4D2020.csv)
I would like to be able to make the conversion much faster than the method described in the help topic. After that I would like to be able to create a chart for each CSV file and also create a chart showing multiple CSV file data.
Mark
Mark_McCoyI see what you're talking about, that output file is mal-formed. The header and the 1st line of data uses comma separated values, then all remaining lines start with a comma and have semi-colon separated values all encased in quotes and even that isn't consistent with the 1st semicolon inside the date-time set of quotes and the rest of the semicolons in their own set of quotes and a whole set of commas.
Basically I think who or whatever is creating this file has some problems and if possible it should get corrected there.
That all said, a macro could be created to facilitate import of this (or the corrected) data, but I don't have the spare time right now to do it. Maybe another helper here does.
Thanks you for pointing out the mal-formed issues. I will go back to the programmer and have him address the issues.
Mark