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