Convert Values with different DecimalSep during LOAD

[#1]

Hi Folks,

i need a solution for this problem. My script reads txt-files. In these files the data are tab seperated. Everything is fine so far, but there is one column in that file that has float values with both DecimalSep like "," and "."

Files that are older than 2007 have comma values and files that are newer use point values. I read the name of the file so i know from which date the values are (0901.txt [January 2009]). So i need to find a way to make a conversation during LOAD that converts all float values from comma to point value. I just want point values like 1.35

How can i do this!?

Thx in advance.

Greetings from Germany.

Frederik Nünning

[#2]

Hi Frederik,

use the "num#" and "num" function.

The num# function evaluates the expression

num#( expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

The num function formats the expression

num

num( expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

Good luck!

Rainer

[johnw]

Maybe this?

replace(MyNumber,',','.')