Changing the separator

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.4
2.1
EnrichProdName
Talend Big Data Platform
Talend Data Services Platform
Talend MDM Platform
Talend Data Management Platform
Talend Big Data
Talend ESB
Talend Real-Time Big Data Platform
Talend Data Fabric
Talend Data Integration
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation
When adding a new dataset from a local .csv file, Talend Data Preparation automatically guesses the separator (or delimiter) to be used, but you can change it.

Procedure

  1. Open the dataset for which you want to change the separator.
  2. Click the cog icon to open the Dataset parameters dialog box.
  3. In the Separator drop-down list, choose the separator that corresponds to your dataset.
  4. Click the Confirm button.

Results

The dataset reloads and the new separator is applied.