CODEWITHSUNDEEP
pentahokettledata-integration
Karthi
Karthi

Reputation: 708

Pentaho Text file out separator

I am using a Text file output step in Pentaho Kettle for extracting data from sql and putting into CSV files. I have specified comma as the content separator. But sometimes I receive the files with semicolon seperated values. Any body else has faced the issue? I have read semicolon seperated values is the default content seperator for CSV file formats. I believe the content seperator is set to default to semicolon. Is this because the content seperator is set to default by the spoon environment based on the input data?

Upvotes: 0

Views: 2248

Answers (1)

Helping Hand..
Helping Hand..

Reputation: 2440

open the text file output step, go to content tab, their you will find option called Separator their what ever you will specify it will come into your final result, by-default you will find semi-column over their so just change it to comma and your problem will get resolved...

Upvotes: 1

Related Questions