Parsing Flat file

Dhara_Goel · July 7, 2008, 10:13pm

I am trying to parse a flat file as shown in the attached file. I am unable to accomplish this.

I have defined each record identifier as “Unlimited” but it fails to gather the 2nd set or records.

Can you please advise?

Thanks
Dhara
sample.doc (907 Bytes)

Sunil_Kumar2 · July 14, 2008, 7:35pm

How you want to parse the file exactly. Whats the structure of your output Document?

Talha_Khan · July 14, 2008, 9:13pm

It looks like a comma delimeted file with recordsWithNoID but what is the record identifier ?

gupta_r.17495 · July 14, 2008, 9:32pm

dogel,

How is your Schema defined…is it as Nth field option and Field seperator (,) and record seperator (newline) and recordWithNoID (RecordDefinition) with maxRepeat=unlimited??

Field Definition as (1,2,3,4,5…nth)

HTH,
RMG

Dhara_Goel · July 14, 2008, 11:37pm

I have resolved this issue.

Thanks for all your responses!

gupta_r.17495 · July 15, 2008, 12:41am

Glad to hear it got resolved!!..

BTW,anything above helped you?? what was the resolution??

Dhara_Goel · July 15, 2008, 1:31am

No.

Although the inbound file is a CSV flat file, I had to define the schema as a heirarchy. Header Record and then the Detail record below that. Each of these was set to “Unlimited”.

This resolved the issue. The inbound csv file had multiple headers and all of those were fetched by convertToValues.

Thanks!!

gupta_r.17495 · July 15, 2008, 2:38am

Sorry i haven’t looked at your file though…anyways it worked for you thats what we care…

But wierd thing is Header record repeats it is definetely unsual…