Space from excel : 0xA0 instead of 0x20

[Anonymous]

When I read my excel file (with a tFileInputExcel), I have some number as 40 654, and the space is a 0x004A instead of a classical 0x0020. The classical Trim method doesn't work.
I could use a my_string.replaceAll("\u00A0","") but I can't understand why it doesn't work. Is there a problem with the encoding of the file?
Thanks for any help.

[Anonymous]

Hi,
The "Trim" option in advanced setting of tfileinputexcel component doesn't work well for case? What's the build version you are using? Could you please show us your excel file for testing?
Best regards
Sabrina

[NicolasTT]

Hi,
No. The "Trim" option in advanced setting of tfileinputexcel component doesn't work well.


I've uploaded the excel file.
Thanks,
Space.zip.zip