Excel file : issues with special characters and spaces in the title when I define a Medatadata Excel Format

[citrods]

hello

I have to handle a excel file with special characters (é, à, è û etc and so on)

For example, here is my input data.

titles are on the first line:

when i define an Medatadata Excel Format, spaces are replaced by "_"and "é" is replaced by "e"

here is my job

and in my output file i have this : the title are not he same anymore as ia sked to keep the title int the settings of the tfuleOutputExcel

Can i have the same title as my input file?

[gjeremy1617088143]

Hi @citr dsz​ ,

for french accent support you can go in talend to Window--> preference -->Talend-->Specific Settings --> checked Allow specific characters for columns of schema.

Space are not allowed by talend (it's a java variable name constraint on column name),

maybe this topic can help you :

https://community.talend.com/s/question/0D53p00007vCpnHCAS/resolved-spaces-in-the-column-headers-of-...

greetings from france

Send me Love and Kudos