String to Number Troubleshooting

[kitkat]

I'm having a hard time trying to convert with what should be a simple task.  Whenever I try to convert strings to numbers, Alteryx doesn't seem to be able to convert it properly through the Select tool.  I even tried using the TONUMBER formula with no success.  Any ideas of what I'm doing wrong?   It could have to do with the text file that we use that is system generated (tab delimited)

This is the look before and after the select tool with a double type field used:

[ivoller · Accepted solution]

It's because of the commas in the string field. Remove / replace these fist and all should be OK.

Cheers,

Iain

[kitkat]

Thank you!  Didn't realize we had to do that fix first

[jaapkluck]

Hi Ivoller,

In my company we do use comma as decimal seperator. Is there any way to get number type fields in my output including Comma as decimal seperator?

Kind regards,

Jaap