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.
i have one Q in our case we have header and we have 3 contents like a , b, c .b is to be neglected only we need to parse a and c this is only for one record so this schema is fixed length and delimited .for the next record delimiter is \n \n and for a b and c delimiter is \n with in a fields are delimited by tab.how to parse this type of file?