nitesh12
01-20-2016, 01:24 AM
I have a word file which is not formatted properly. I need to pick specific values which are mentioned below
1.account number (14 digit long),
2.name,(first line)
3.scheme code,(5 alphanumeric)
4.account balance(alphanumeric with suffix as Cr or Dr)
5.total overdue
6.last rephased on (date in dd-mm-yyyy)
sample is as pasted below:
Mr.XYZ
--------------------------------------------------------------------------------------------------------------------------------
Account Number : 01180600999999 Currency : INDIAN RUPEE Account Balance 66,177.00Dr
Scheme : LA001 Last Rephased on : 07-03-2000 Schedule Number : 01 Interest Liability 0
--------------------------------------------------------------------------------------------------------------------------------
Flow Flow Date of Demand Amount Last Adjust- Amount Adjusted Due Date Days
Type Description Demand ment Date Overdue
--------------------------------------------------------------------------------------------------------------------------------
PRDEM PRINCIPAL DEMAND 07-04-2001 25,000.00 0.00 08-04-2001 5399
INDEM INTEREST DEMAND 17-11-2007 41,177.00 0.00 19-11-2007 2983
--------------------------------------------------------------------------------------------------------------------------------
TOTAL OVERDUE : 66,177.00
--------------------------------------------------------------------------------------------------------------------------------
I need to extract the data typed in bold letters and paste into another excel file in 6 different columns.
Please help.
1.account number (14 digit long),
2.name,(first line)
3.scheme code,(5 alphanumeric)
4.account balance(alphanumeric with suffix as Cr or Dr)
5.total overdue
6.last rephased on (date in dd-mm-yyyy)
sample is as pasted below:
Mr.XYZ
--------------------------------------------------------------------------------------------------------------------------------
Account Number : 01180600999999 Currency : INDIAN RUPEE Account Balance 66,177.00Dr
Scheme : LA001 Last Rephased on : 07-03-2000 Schedule Number : 01 Interest Liability 0
--------------------------------------------------------------------------------------------------------------------------------
Flow Flow Date of Demand Amount Last Adjust- Amount Adjusted Due Date Days
Type Description Demand ment Date Overdue
--------------------------------------------------------------------------------------------------------------------------------
PRDEM PRINCIPAL DEMAND 07-04-2001 25,000.00 0.00 08-04-2001 5399
INDEM INTEREST DEMAND 17-11-2007 41,177.00 0.00 19-11-2007 2983
--------------------------------------------------------------------------------------------------------------------------------
TOTAL OVERDUE : 66,177.00
--------------------------------------------------------------------------------------------------------------------------------
I need to extract the data typed in bold letters and paste into another excel file in 6 different columns.
Please help.