-
How to copy different values from unsorted word file and paste the result in excel
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.
-
Hi, nitesh12
Does the file consist only data of one person (1 file for 1 person) or more than one person per file?
Can you provide more than one sample? It's important because I need to see the "pattern" in the document.
For the word "Mr.XYZ", is there any word before or above it? maybe "name:"?
Last edited by akuini; 01-29-2016 at 02:09 AM.
Reason: make it clear
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules