topic Column names with spaces in Talend Studio

Column names with spaces

Anonymous — Sat, 16 Nov 2024 14:03:12 GMT

I need to create an excel output file that uses column headers with spaces, it doesnt look like this is possible is there any work around? I need to you spaces I cannot use _
thanks

Re: Column names with spaces

Anonymous — Wed, 04 Mar 2009 05:11:16 GMT

Hello
Column name can't contain spaces. You can use underline '_'.
Best regards

shong

Re: Column names with spaces

Anonymous — Wed, 04 Mar 2009 19:22:47 GMT

A little more information, I

Re: Column names with spaces

Alessandro_Lachina — Thu, 24 Jan 2013 10:28:41 GMT

why? Excel give the possibility to use space in column name

Re: Column names with spaces

Anonymous — Thu, 24 Jan 2013 10:32:28 GMT

why? Excel give the possibility to use space in column name

Talend Studio is a Java code generator, a Talend job will be translated to a Java Class, a column on the schema will be a variable in the class, a variable with space or special character is not allowed in Java.
Shong

Re: Column names with spaces

Alessandro_Lachina — Thu, 24 Jan 2013 11:33:01 GMT

any workaround??

Re: Column names with spaces

Anonymous — Thu, 24 Jan 2013 11:56:42 GMT

any workaround??

Column name can't contain spaces. You can use underline '_' or Talend will replace automatically space with "_" when retrieve schema.
Shong

Re: Column names with spaces

Anonymous — Thu, 24 Jan 2013 20:04:05 GMT

You cannot specify column names in Excel. You can write anything you want in the first line and decide to call it header line. That's why it looks like Excel allow spaces in column names but actually there are no column names other than the build in name like "A" or "AB"

Re: Column names with spaces

_AnonymousUser — Thu, 24 Jan 2013 22:50:56 GMT

hi,
you can generate the 1st line with a tFixedFlowInput and complete your excel file without column titles.

Re: Column names with spaces

Anonymous — Wed, 10 Jul 2013 16:23:10 GMT

We have a hard requirement to create output columns with spaces. I wrote this to a co-worker - any better alternatives? We try to stay Talend only, no external utilities like sed.
It will be ugly: You'll have to do 3 things:
1) write out the header to a temp file with tokens like +++SPACE+++ where there should be spaces (make the column name First+SPACE+Name).
2) rewrite the header out to the real output location, using java, String.replace " " for the token - you can write it out as a one column schema and tFileOutputDelimited for example, using some delimeter that will never come up
3) append to the header file with the real data
So that is a terrible solution but I think what we'll end up with.

Re: Column names with spaces

Anonymous — Thu, 11 Jul 2013 04:32:20 GMT

Hi
As Cedric LECLERC said, use a tFixedFlowInput to write the header data to the file first, and then append the record to the same file in next subjob.
Shong