topic Re: Adding Special Characters in Talend Studio

Adding Special Characters

Anonymous — Sat, 16 Nov 2024 03:44:28 GMT

I am trying to create an excel file where one of the column labels is #SKIP

However, hen I try to add # in tmap it doesn't allow it to happen. Is there a way I can allow it to add #SKIP? Do I need to directly edit the source code for this to happen?

Re: Adding Special Characters

Anonymous — Thu, 26 Dec 2019 06:29:50 GMT

Hello,

The Spaces, double-byte spaces, #, ~, etc are depend on DBMS actually.
Please try to set your studio as following;
Window -> Preference -> Talend -> Special Settings -> checkout "Allow specific characters,,,," to see if it works?

Best regards

Sabrina

Re: Adding Special Characters

Anonymous — Thu, 26 Dec 2019 15:27:05 GMT

No luck, unfortunately.

If I am going from postgres to excel and using tMap to add the column #SKIP is it still dependent on DBMS?

Re: Adding Special Characters

Anonymous — Fri, 27 Dec 2019 03:19:35 GMT

Hi dfree
Talend Studio is a Java code generator, the special character # can not be the first character of a variable name( the column name in Talend).

Regards
Shong