CSV File changing fields (text to number, and decimal separators)

[#1]

Hey guys,

Nowadays I use excel files for a qlikview document, but it has taken quite long time to extract them from my program. We have as an alternative use .csv files, but when I load it, the fields comes as text, and the separator is "."... I want to change this separator to "," (comma as decimal separator), and them make qlikview read this text as numbers.

I tryed to use num#() formula, but it's not working, i think it's due this separator.

So, how do I change that?

Thank you,

[rbecher]

But you could build a set of similar test data...

[#3]

sorry guys, i'll hold this topic for some time, have other business to do...