Hello,
i have a problem while trying to access a .csv file. i get the massage (FOC209) DATA VALUE EXCEEDS ITS LENGTH SPECIFICATION
i am trying to access a csv. file with two columns. Here is my master file and the fex code.

FILENAME=BASIS, SUFFIX=COM , $
SEGMENT=BASIS, SEGTYPE=S0, $
FIELDNAME=KU_NR, ALIAS=E01, USAGE=A10, ACTUAL=A10, $
FIELDNAME=KU_NAME, ALIAS=E02, USAGE=A300V, ACTUAL=A300V, $


FILEDEF BASIS DISK C:\10059441\BASIS.csv
TABLE FILE BASIS
PRINT
'BASIS.KU_NR'
'BASIS.KU_NAME'

END

Christian

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

Usually this message means that one of the fields has a valuye that is longer than what's specified in the master.
But I have my doubts about the variable length format of the second field.
Steps I would take:
1. Give KU_NAME a non-variable format, like A300 and see if this resolves the issue.
2. Take a look at the csv file itself, using a text editor. It may be possible that it is actually not a comma separated file but semi-colon separated. If the source is Excel, this happens quite a lot and results in this situation.

Hi GamP,
after replacing the semi-colon with comma i get the message that there are more values than fields in the mfd.
Christian

If the lines in the csv file do not end with a ,$ you need to SET PCOMMA=ON.

Also check that KU_NAME values do not contain a comma.

In that case, there has been one or more fields that originally contained a comma.
Because excel used a semi-colon to separate the fields, it did not take extra care to enclose fields that contain a comma in double quotes.
In this case it may even be best for you to go back to the orignal csv file and use a slightly different master file. Not command delimited but fixed delimited. You can specify the delimiter to be used. Suffix is DFIX, look it up in the doc.
Otherwise you'd have to look up all fields that have a comma, replace the comma by something else or enclose the field in " ", and then replace all ; by ,.

Hi GamP,
i used the DFIX Method!!! Works great!!!
Thanks a lot to all!!!
Christian