Fixed length with multiple sub records file

CloverDX Platform
1

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

2

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.

3

Thanks Agata. I’ll try that.