Hey @takbb , as usual, thanks for the input.
Indeed, the options look to be characters to look for on the incoming string, and it kinda what the option says (which I missed):
It looks like the String to Number would add the thousand separator regardless.
In relation to the separators not being included in the number, it’s definitely something that I would want, as the separators should be for display only - it all depends on what want to achieve in the end, and this is a personal preference.
My reason being, I don’t want to lose the real value of these records, in case I need to do operations on them, and you can’t process them if they physically have these separators in them. With the separators physically in them, they’re basically strings - think of storing these values in a db table, you would want to keep them as numeric in the db, and render the separator only for display.
Again, it depends on what you want to achieve