sbierig
03-24-2006, 13:28
I have a relatively simply flat file structured like this:
SKU=1234567
Date=12/12/2006
desc=widget
class=9
classDesc=sample data
subClass=B
subClassDesc=more data
I am using a delimited schema and setting up each line as a new record with newline as the record delimiter and = as the field delimiter.
90% of the file parses correctly but the subClassDesc gets added as a child record within subClass. The subClassDesc value is parsing correctly but the child record name within subClass is also named subClass (and not subClassDesc). Also, an error generates that /subClass/subClass is an unexpected record. It is as if the parser, when reaching subClassDesc stops in the middle of the term and assumes it is the previous record name.
This only happens for a few 'records' within the structure. For example, the lines with class and classDesc parse fine. I checked each entry in the schema definition and even the hex of the flat file and am at a loss.:confused:
Thanks in advance for your assistance!
SKU=1234567
Date=12/12/2006
desc=widget
class=9
classDesc=sample data
subClass=B
subClassDesc=more data
I am using a delimited schema and setting up each line as a new record with newline as the record delimiter and = as the field delimiter.
90% of the file parses correctly but the subClassDesc gets added as a child record within subClass. The subClassDesc value is parsing correctly but the child record name within subClass is also named subClass (and not subClassDesc). Also, an error generates that /subClass/subClass is an unexpected record. It is as if the parser, when reaching subClassDesc stops in the middle of the term and assumes it is the previous record name.
This only happens for a few 'records' within the structure. For example, the lines with class and classDesc parse fine. I checked each entry in the schema definition and even the hex of the flat file and am at a loss.:confused:
Thanks in advance for your assistance!