little Dataport prob

daroon

Hi,

dos anyone know how to import data (Decimal) wich is in following format in a text file
000098.40
Navision imports it as
9840,00
When i change the Text file into
000098,40
then Navision imports it right as (98,40).
Is there a way to say Navision to use the point as decimal separator ??

Thanx for you help

Ronnie

Quasimodo

Hi Ronnie,

if your var, which helds 000098.40 is called e.g. var1, than execute
var1 := convertstr(var1,'.',',');
this will change your value to 000098,40 an NF will read it as decimal.

Michael

goldeneye

You'll have to import the field to a text variable called 'var1' for that naturally.

ivor

You can also use

OnBeforeEvaluateField(VAR Text : Text[260])
Text := CONVERTSTR( text, '.', ',');

Then you don't have to make a variabele

gr. Ivor van Son