topic For Imput String in Talend Studio

For Imput String

Anonymous — Mon, 09 Mar 2020 15:11:03 GMT

Hi,

i need help!, I read many forums and tried in many ways but I can't find a solution.

TRF — Mon, 09 Mar 2020 15:24:49 GMT

The input value contains a comma "," where a decimal point "." is expected (should be 10.78 instead of 10,78).

You should try to change the default settings for tFileInputExcel component.

Go to "Advanced settings" tab.

Tick the option "Advanced separator (for numbers)" the change the value for both fields "Thousands separator" and "Decimal separator" like this:

Anonymous — Mon, 09 Mar 2020 15:30:21 GMT

thanks for you reply, but i had already tried (and the error its the same)

also i changed the number to "." in excel and throws the same mistake.

sorry for mi english.

TRF — Mon, 09 Mar 2020 15:46:09 GMT

It seems you have the same character for both separators. Maybe my eyes, else change the 1rst one to "," and the 2nd to "."

Anonymous — Mon, 09 Mar 2020 16:09:37 GMT

I had tried and it didn't work, but now yes, thank you very much!