topic Re: [resolved] special characters in field names - CSV file using hyphen "-" header in Talend Studio

[resolved] special characters in field names - CSV file using hyphen "-" header

Si4 — Sat, 16 Nov 2024 12:40:12 GMT

Excuse the first time user question, but I have fallen at the first hurdle creating my first job.
The output CSV file needs specific header column names such as "first-name"; I cannot change this. When I define this in Talend it changes the field in the schema to "first_name" (underscore not hyphen) and i cannot seem to override or escape this.
Help.
Thanks
Si

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Anonymous — Thu, 22 Sep 2011 08:38:50 GMT

Hi
Talend don't support the special characters like hyphen "-" in the column name.
Best regards
Shong

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Si4 — Thu, 22 Sep 2011 10:24:02 GMT

Thanks for the quick reply,
OK but then there must be a solution?
Lets say I put the header row in another file and then combine the output rows with that row to the output file - then I get the header coloumn names I want?
Cheers
Si

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Si4 — Fri, 23 Sep 2011 13:36:35 GMT

OK - Now I have tried using tUnite to combine the data with a file containing the header row (with illegal characters) and that works fine except no matter how I set the tUnite merge order it always comes out the wrong way.
Any ideas what I am doing wrong?
Cheers
Si

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Si4 — Fri, 23 Sep 2011 14:00:09 GMT

OK - searching further suggests that tUnite does not guarantee the field order on the output.
Change this to be a job for the header and a sub-job activated after the header job to append the data.
Sigh.
Si

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Anonymous — Tue, 02 Apr 2019 01:17:43 GMT

Hi All,

Has this been solved yet? if not is there a workaround to inserting special characters into column names? my example:

"cost_centre_id" needs to be "cost-centre_id" but it is not letting me use it.

Please help.

Thanks,

John

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

Sriram151515 — Sat, 02 Jan 2021 10:19:41 GMT

Hi All,

@Shicong Hong @si smith : Is there a solution identified for the above issue. Stuck with a requirement to use special characters in the column header eg: "attributes.name"

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

SJeshwani1618330394 — Sat, 12 Jun 2021 12:51:27 GMT

Hi All,

Is there a workaround to inserting special characters into column names?

For example: location_latitude to location-latitude

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

gjeremy1617088143 — Mon, 14 Jun 2021 06:37:12 GMT

Hi,you can create your file with a column name with non special characters,

then you read it with a tFileInputRaw as a unique String,

then you replace it ex : StringUtils.replace((your string),(the old column name),(the new one with special char))

finally you write it with tFileOutputRaw.

Send me Love and Kudos

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

dramirez29 — Fri, 18 Jun 2021 21:26:29 GMT

What component do you use to replace?

tjava ?

Re: [resolved] special characters in field names - CSV file using hyphen "-" header

gjeremy1617088143 — Mon, 21 Jun 2021 07:39:06 GMT

Hi , TJavarow or Tmap.

Send me Love and Kudos