Hello,
with the help of the forum i could connect a .csv file to a master file. i used the DFIX Method because
i have large textfields with commas inside. Now i have a problem with Decimal values. When I use
D20.2 in the master file or D18.2 or whatever DXX.2 i see only .00 in the output.

Christian

This message has been edited. Last edited by: Kerry,

Please let us see the MFD you use.

Here we are:
FILENAME=BASIS, SUFFIX=DFIX , $
SEGMENT=BASIS, SEGTYPE=S0, $
FIELDNAME=KU_NR, ALIAS=E01, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=KU_NAME, ALIAS=E02, USAGE=A255V, ACTUAL=A255V, MISSING=ON, $
FIELDNAME=LAND, ALIAS=E03, USAGE=A100V, ACTUAL=A100V, MISSING=ON, $
FIELDNAME=BA_NR, ALIAS=E04, USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=BUSINESS_AREA, ALIAS=E05,USAGE=A255V, ACTUAL=A255V, MISSING=ON,$
FIELDNAME=OU_NR, ALIAS=E06,USAGE=A10, ACTUAL=A10, MISSING=ON, $
FIELDNAME=OPERATING_UNIT, ALIAS=E07,USAGE=A255V, ACTUAL=A255V, MISSING=ON,$
FIELDNAME=OSU_NR, ALIAS=E08,USAGE=A10, ACTUAL=A100, MISSING=ON, $
FIELDNAME=OPERATING_SUB_UNIT, ALIAS=E09,USAGE=A255V, ACTUAL=A255V, MISSING=ON, $
FIELDNAME=STRASSE, ALIAS=E10,USAGE=A255V, ACTUAL=A255V, MISSING=ON, $
FIELDNAME=PLZ_ORT, ALIAS=E11,USAGE=A255V, ACTUAL=A255V, MISSING=ON, $
FIELDNAME=TELEFON, ALIAS=E12,USAGE=A255V, ACTUAL=A255V, MISSING=ON, $
FIELDNAME=feld1, ALIAS=E13,USAGE=D20.2, ACTUAL=D20.2, MISSING=ON, $
FIELDNAME=feld2, ALIAS=E14,USAGE=D20.2, ACTUAL=D20.2, MISSING=ON, $
FIELDNAME=feld3, ALIAS=E15,USAGE=D20.2, ACTUAL=D20.2, MISSING=ON, $
FIELDNAME=feld4, ALIAS=E16,USAGE=D20.2, ACTUAL=D20.2, MISSING=ON, $
FIELDNAME=DELIMITER ,ALIAS=';' ,USAGE=A1 ,ACTUAL=A1 ,$

Christian

Christian

As this is a csv file, I assume that the file is readable, that is the value for the the D20.2 is something like 1233456.78.

In which case use an ACTUAL of A20 with the USAGE of D20.2.

Or ....
The data is in the file as 20,44 - thus needing CDN to be on to be able to read it correctly.
Try it and see if it helps.

Sorry CDN=ON does not help!! my output looks like this:
KU_NR feld1
101 ,00
705 .
706 .
1500 ,00
1510 .
1520 .
4160 .
4161 ,00
4163 ,00
4180 .
4181 .
4575 .
5235 ,00

Christian

Could also be that it is the other way around. That you have CDN set to ON by default and that it needs CDN to be OFF for this file. Anyway, the easiest way to check what's in the file is to edit the master file and change the ....

HOLD IT

Just checked your master. The ACTUAL format should be A20! USAGE is OK.

Hello GamP,
i got it with CDN=ON and ACTUAL of A20 with the USAGE of D20.2. it works!!!
In Germany we say who can read has a great advantage!!!
Christian