Fixed length with multiple sub records file

alci

• July 09, 2008 00:00

• Answered

Follow

Hi,

I must process files that have the following type of format:

- fixed length fields, with one field indicating the number of children
- multiple sub records (children)

eg.

headernr1, attr1 attr2, nrofchildren=2, childnr1, text1ofchild1, child2, text1ofchild2
headernr2, attr1 attr2, nrofchildren=1, childnr1, text1ofchild1
headernr3, attr1 attr2, nrofchildren=3, childnr1, text1ofchild1, child2, text1ofchild2, child3, textofchild3
etc.

Is there a way to process this with Clover ?

Thanks for you tips,
Franck

• 

  avackova

  • July 09, 2008 07:14

  0

  Comment actions Permalink

  Hi,
  you have to read the file by Universal Data Reader (you can use mixed record - some fields are fixed length and some delimited) and then normalize records by Normalizer component.
• 

  alci

  • July 10, 2008 15:49

  0

  Comment actions Permalink

  Thanks Agata. I'll try that.

Please sign in to leave a comment.