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,

[fernando_tonial]

hi, you can try this in script.

Num(Replace(Filed,'.',',')) as Number

Best Regards.

Tonial

[rbecher]

Hi Julio,

why num#() is not working? Have you tried with all parameters:

num#(field, '#0.00', '.', ',') as MyNumber

- Ralf

[#4]

Hey Ralf, i'll try with those, i haven't tried with all parameters...

[#5]

Ops... virtual memory exceeded... My database das 180,000 lines x 25 columns that needs to be transformed... Is it too much perhaps?

[Anonymous]

Did you try to manipulate this?

SET MoneyDecimalSep=',';  SET MoneyDecimalSep='.';

Alternatively, Add a layer of transformation from xls to QVD before using your data.

[#7]

I tried that, some values started to appear, but it's like 10% of everything... I don't have a clue why, but it was worth the shot.

[Anonymous]

OK. Could y ou maybe post examples of some records (or an small extract in XLS and CSV)?

[Clever_Anjos]

These are 'peanuts' to QlikView.

Could you post a sample of your csv?

[#10]

I can't upload samples, those are classified =[