Well, it works in the v7 and so, i again run with the file which i work above (Not the one that I made for you). It doesn't work.
I think that when I received the file, it was in format xlsb and i save the file in the format xlsx because Talend can't read the format xlsb. It maybe broke the file.
But i don't understand why this line doesn't work and the others lines work very well.
The numberformatexception is because (I'm guessing) of the comma. Your environment settings probably have the decimal separator set to ".". As such, a comma "," as the separator will cause this. It's a pretty common error to come across when you are converting from a String to a number and your system is not expecting (for example) French number formatting in English.
The line does not work because you are trying to remove characters that you do not know of. The best way to work this out is to use a tool to identify the characters and then remove those. I think you may be right with your assumption about the conversion of an xlsb to xlsx. Unfortunately, I cannot help any more than this unless I can recreate the issue. Everything I have tried has worked.
I don't believe this is a Talend issue though, it is just simple Java. As I said, I think this is a case of just not knowing the characters that have been added to the number.
Thank you for your answers. I am going to put aside this line, I shall speak with my colleague when he will come back from his holidays. Maybe, he will know how to identify the characters and then remove those.
U+0031 : DIGIT ONE
U+0020 : SPACE [SP]
U+0033 : DIGIT THREE
U+0034 : DIGIT FOUR
U+0036 : DIGIT SIX
U+0020 : SPACE [SP]
U+0034 : DIGIT FOUR
U+0031 : DIGIT ONE
U+0037 : DIGIT SEVEN
