How to read tabular data from email body and store it in rdbms

[Sai_M_21]

Hi,

I need to read a tabular data from email and store that in the db.

When I am trying to use the tFileInputMail component, I can read the whole body of the email and store that as a string.

But how to get the data from the tabular column alone for the email and store that in the db??

or how to get data of the tabular column from the output of the

tFileInputMail ?

[sagu]

Please refer below link how to read email in Talend

https://help.talend.com/r/Ixfbj5J7PuzfSwFwMXxUpg/4iyWMTo9y7R7MX9StT9ssw

[Sai_M_21]

yes I am using tFileInputMail for reading the body of the email, it reads the whole body of the email and stores it as a string.

However I need to have only the tabular column data from the email or else I am looking a process to extract the tabular data from the whole string read.

[Anonymous]

what does the body string look like ? Can you show an example? we will see how you can extract the expected data from the string.

[Sai_M_21]

Body of the email looks like below image:String obtained after using tFileInputMail looks some thing like below:

FIXED

             $250-$500          $501-$750      >$750

TV          2          6           4

Mobile               1           2           5

ON-HOLD

             $250-$500          $501-$750      >$750

TV         8           10         0

Mobile               34         23         2

Laptop               6           0           3

The above email body should be retrieved and stored in db in the below form: