Space from excel : 0xA0 instead of 0x20

Four Stars

Space from excel : 0xA0 instead of 0x20

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.
Moderator

Re: Space from excel : 0xA0 instead of 0x20

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Space from excel : 0xA0 instead of 0x20

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