how to create mate data in talend

[Anonymous]

Hi Team,

I have txt file, i want to load in oracle table. Below is file format. It is possible to create meta data from below file contents in talend.

Report:212
date:21-02-2019
------------------------
no name col3
------------------------
02 sanajay sagar
03 xxx yyy

Report:213
date:21-02-2019
------------------------
no name col3
------------------------
05 zxz sa
06 ew qa

ID: 121
Row count: 4

Thanks

Shree

[Anonymous · Accepted solution]

Yes, please test the job flow and accept the post as solution if it fixes your need, it will helps others find helpful answers in the community too!

Regards
Shong

[Anonymous]

Sure Shong.

Thanks you!.

Regards

Shree

[Anonymous]

Hi Shong,

Awesome, I have tested flow as you mention its working as expected.

Small queries, This flow will work source as excel file.

Thank you so much.

Regards

Shree

[Anonymous]

Hi Shong,

I tried your flow its worked, i have remove almost unwanted records.

I got some issue the file records after cleaning some data. I have attached 2 records. This file is system generated file.

In the each single records split 4 line of code due A4 size width. Half records move to next line.

Can you check the line records in notepad++. How to add next line into single lines. Please let me know if you need any information.

Thanks Shree

sample records.txt