We have a list as CSV and have to make sure that we have semicolons as separator on each line. Who can help us to fix that problem automatically?
we can provide some samples.
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro (which Excel version doyou prefer?) contained in a separate XLS (or XLSM) file.
This approach makes further use of the macro very convenient by offering usual Open file dialog to identify the current input CSV file.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
If you send me a sample file, I'm ready to create a draft pilot in order to make sure everything is rightly understood.
Regards!
I am assuming you want each line of data to end in a ;.
I can create a small utillity program which will read the csv file line by line, check if it ends in ; and if not add it.
I will only work in windows and can be xp or 7 which ever is required
Dear Sir,
I can create a small executable desktop program what will check an each line of your csv file(s) for semicolon separator.
Yours faithfully,
Marian Morzol