How to create Flat File Schema For .txt file contents?

, ,
1

Hello

How to create and process text file contents below.

Text file Contents-
±------------±----±-----±-------+
|Sort criteria|Ascdg|Descnd|Subtotal|
±------------±----±-----±-------+
|Group | X | | |
±------------±----±-----±-------+
valid to 14.09.2016

±----±----+
|ABC|DEF|GHI|
|45 |56 |67 |
|78 |78 |90 |
±----±----+

Text file Content is flat file appended with additional data.

Can someone please suggest how to extract flat file from text file and process the same.

Best Regards

Bhavna Vasanth

2

sample data is not very clear. will you be able to upload file here?

3

Sample file is attached.

Flat file data is extracted now by skipping headers from file.

Any ideas on how to skip the additional line that is in end of file.

It appears in the extracted flat file records
sample.txt (311 Bytes)

4

Deleted extra document at the end using pub.document:deleteDocuments service .Topic is closed.

Thank you!

Bhavna Vasanth

5

Cool, you resolved issue by yourself. You proved self help is the best help :smiley:

Thanks,