Flatfile Schema with header

The below is my Flat file content.

<<ins>aaa</ins>|<ins>sender</ins>|Store|test21|2020-10-21T12:01:00> … (header part)
<ins>aaa</ins>|<ins>bbb</ins>|<ins>ccc</ins>
<ins>aaa</ins>|<ins>bbb</ins>|<ins>ccc</ins>
<END|<ins>2</ins>> … (Footer part)

in the <> header and footer is mentioned.
And I want to retrieve date from header , body and footer in single Schema Document. like below.

-header
-sender
-timestamp etc

-body (Multiple records)
-id
-number
-amount
-date
-status

-Footer
-count

and in body section, delimiters for new record is (newline) and field is (|).
How can I defined schema dictionary ?

#flatfile

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.