topic Re: output file with .csv format in Talend Studio

output file with .csv format

Anonymous — Sat, 16 Nov 2024 07:12:05 GMT

Hi,

I am facing an issue. I want to save file .csv extension but not the columns separated with delimiter. I want every column to be in different cell.

For example,

I want

Name	Age
ABC	12

But, using tFileDelimited component, I am getting as

NameAge

ABC12

I know, this is possible by creating excel file, but I want csv file.

Is there any solution?

Thanks,

Suneel.

Re: output file with .csv format

Aukema — Tue, 27 Nov 2018 11:21:07 GMT

Hi,

A cell is not plain text csv. Do you mean to output to Excel (tFileOutputExcel) or do you mean outputting a readable format like with tFileOutputPositional?

Re: output file with .csv format

Anonymous — Tue, 27 Nov 2018 13:12:19 GMT

By default, tFileOutputDelimited uses a semi-colon ( for the delimiter. If you save the file as a .csv, then open it in Excel, it expects the delimiter to be a comma, and you will see all your data in one cell. Try changing the delimiter in the component to a comma and see if that fixes the problem.

Re: output file with .csv format

Anonymous — Tue, 27 Nov 2018 13:29:40 GMT

I meant for csv file to look like the example I have mentioned. I think tFileOutputPositional will not fulfill my requirement.

Re: output file with .csv format

Anonymous — Tue, 27 Nov 2018 13:34:00 GMT

Thanks..!!!

This solved my problem.

Re: output file with .csv format

Anonymous — Thu, 13 Dec 2018 11:23:45 GMT

Hi,

Choosing comma as delimeter solved my problem. But, if the input data column has comma in it, it is treating as seperate data. I mean if the data is like ABC, DEF which is a single string is treated as two different columns.

Can I get solution to this?

Thanks,

Suneel.

Re: output file with .csv format

cterenzi — Thu, 13 Dec 2018 20:32:28 GMT

If the input file is properly wrapping data elements that contain the delimiter in quotes or some other enclosing character(s) in the "Text enclosure" setting of tFileInputDelimited.

For a standard quote enclosure, I use "\"" as my setting.

If your input file does not enclose text strings containing a delimiter, this is an error that will need to be addressed at the source of the file.

Re: output file with .csv format

Tseelee — Sun, 15 Nov 2020 12:11:36 GMT

8904ghxhteyrteyt4r2q83w-

Re: output file with .csv format

Tseelee — Sun, 15 Nov 2020 12:11:58 GMT

hello