Extract_Notepad_Table_Data to excel

[Mankum]

Hi All,

I want to extract only table data of notepad to excel.

My issue is that, I have Multiple notepad data which contains at least one table of data. I need to extract only Table data from notepad not any other data.

I hope, am clear with my query.

Please do let me know if any clarification needed. Also, this is very urgent request. If anyone can solve this I would be obligated to him/her.

Please solve my issue.

Thanks in advance,
Manish Kumar

 

[Logit]

How did you create a table in Notepad ?

 

[Mankum]

Data copied from somewhere else and pasted it into Notepad. Like below

DATE_OF_ACTIVITY : 09182015_1107_WED
CLASS : 4D SEC : C
REPORT : MONTH_WISE_REPORT USER : ABC

S.NO NAME MATHS_MARK SCIENCE_MARK TOTAL AVERAGE
---- ---- ---------- ------------ ----- -------

0001 HARISH 785.26 856.87 1642.13 M
0002 GANSDD 45.65 10.00 55.65 T

0003 HASASA 12.00 10.00 22.00 M
0004 HAAFFG 11.00 10.00 21.00 Y
END OF SERVICE = DATA

 

[Logit]

Is that all of the data located in Notepad or is there more before or after ?

What portion of what you have posted is the actual Table ? What part of what you have posted is to be extracted to Excel ?

The data is repeated, once above in a nicely formatted presentation and below in a cobbled view. Are both to be extracted to Excel or
is there more to be extracted as well ?

 

[Mankum]

Yes!!

 

[Mankum]

Has anyone have any idea about above query?