Adding Special Characters

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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