# Text Delimiter

The **"Text Delimiter"** field defines the character used to enclose text fields in the CSV file, ensuring correct data interpretation even when they contain special characters. The system offers three main options:

[![image-1756458421896.png](https://manual.vtenext.ch/uploads/images/gallery/2025-08/scaled-1680-/h1KsiRZla6TscjkW-image-1756458421896.png)](https://manual.vtenext.ch/uploads/images/gallery/2025-08/h1KsiRZla6TscjkW-image-1756458421896.png)

<div id="bkmrk-double-quotes-%28%22%29---"><div><div data-test-render-count="1"><div><div data-is-streaming="false"><div><div><div>- **Double Quotes (") - Recommended** Double quotes represent the international standard for CSV files: 
    - Example: "Mario Rossi","Via Roma, 123","Milano"
    - Advantages: 
        - Universal standard recognized by all software
        - Protects fields containing commas (field separator)
        - Correctly handles text with leading/trailing spaces
        - Guaranteed compatibility with Excel, LibreOffice, Google Sheets
    - Usage: Recommended for all standard exports
- **Single Quotes (')** Single quotes offer a less common alternative: 
    - Example: 'Mario Rossi','Via Roma, 123','Milano'
    - Advantages: 
        - Useful when text frequently contains double quotes
        - Reduces the need for character escaping
    - Disadvantages: 
        - Less compatible with standard software
        - May cause interpretation issues
    - Usage: Only in specific cases or for compatibility with particular systems
- **No Delimiter** The no delimiter option eliminates any protection character: 
    - Example: Mario Rossi,Via Roma 123,Milano
    - Advantages: 
        - Lighter and more compact files
        - Faster processing
    - Disadvantages: 
        - Serious problems if data contains the field separator
        - Loss of precision with leading/trailing spaces
        - Incompatibility with many standard software applications
    - Usage: Not recommended; use only if certain that data contains no problematic characters

</div></div></div></div></div></div></div></div>**Recommendation:** Always use double quotes (") to ensure maximum compatibility and data protection, especially in the presence of complex text or addresses containing commas.