CSV Converter: Fixing errors with invalid CSV
This video is about Fixing errors with invalid CSV
On this example I am using Open Office on Mac OSX. The options on Windows might be a little different but the principle is the same.
Step by step:
1. Open the file manager and double click the CSV file, or right click and Open in Excel.
2. The first screen will ask how you want Excel to recognise the field delimiters and text delimiter. You can select one or more, as soon as you click on the options, you will see the effect below.
3. Click on the File menu and Save As. Excel will ask you where to save the file. You can either override the same file or save with a different name.
4. You should tick the option 'Edit filter settings'.
5. When the prompt for field delimiter shows, choose semicolon (;). For text delimiter choose double quotes ("). I also tick the box to Quote all text cells.
Read more http://www.csvconverter.biz/blog/how-...
In questa pagina del sito puoi guardare il video online CSV Converter: Fixing errors with invalid CSV della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Marcelo Vani 15 luglio 2015, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,806 volte e gli è piaciuto 4 spettatori. Buona visione!
