AMAPstudio

User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 09:14]
coligny
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 09:54] (current)
coligny
Line 1: Line 1:
 ====== Excel adds double quotes around some fields during CSV file export ====== ====== Excel adds double quotes around some fields during CSV file export ======
  
-If you build or tune your data files with Excel, you may use its 'Save As CSV file' or 'Save As tab delimited file' feature to get a text file with a tab separator ​betwenn ​columns, which is a standard for input files in Capsis (e.g. inventory files, species files, soil compartment files, configuration or parameter files...).+If you build or tune your data files with Excel, you may use its 'Save As CSV file' or 'Save As tab delimited file' feature to get a text file with a tab separator ​between ​columns, which is a standard for input files in Capsis (e.g. inventory files, species files, soil compartment files, configuration or parameter files...).
  
 The exported file may contain sections like this small extract: The exported file may contain sections like this small extract:
Line 11: Line 11:
 </​code>​ </​code>​
  
-But sometimes, you may instead get something with extra double quotes, looking like this: +But sometimes, you may instead get something ​**with extra double quotes**, looking like this: 
  
 <​code>​ <​code>​
Line 23: Line 23:
 This extra double quotes addition seems to be done by the 'Save As' feature in Excel. A workaround has been found to get the expected result, based on Copy and Paste, here is an example of how it can be done. This extra double quotes addition seems to be done by the 'Save As' feature in Excel. A workaround has been found to get the expected result, based on Copy and Paste, here is an example of how it can be done.
  
-  - **Open a simple text file editor** (e.g. Textpad, NotePad++, SciTE, gedit...) and create a new empty document +  - **Open a simple text file editor** (e.g. Textpad, NotePad++, SciTE, gedit...) and create a new empty document. 
-  - **In Excel, select the range of cells** to be exported (you may try **Ctrl+A** to select faster the whole document to check if it works) +  - **In Excel, select the range of cells** to be exported (you may try **Ctrl+A** to select faster the whole document to check if it works). 
-  - **Copy the selection** in the system clipboard with **Ctrl+C** +  - **Copy the selection** in the system clipboard with **Ctrl+C**. 
-  - **Paste it in the empty document** in the text editor with **Ctrl+V**+  - **Paste it in the empty document** in the text editor with **Ctrl+V**.
   - **Save** the resulting text file.   - **Save** the resulting text file.
  
-Below is an example of a complex input file with several different sections for the Samsara2 model, which can benefit from this simple technique.+Below is an example of a complex input file with several different sections for the Samsara2 model, which can benefit from this simple ​Copy/​Paste ​technique.
  
 <​code>​ <​code>​
  
 # Model : samsara2  # Model : samsara2
-# Author : ​Beno? Courbaud +# Author : ​Benoit ​Courbaud
 # Project : sam  # Project : sam
 # Stand date : 2012  # Stand date : 2012
documentation/exceladdsdoublequotesduringcsvexport.1571994848.txt · Last modified: 2019/10/25 09:14 by coligny