PDA

View Full Version : How to copy different values from unsorted word file and paste the result in excel



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.

akuini
01-29-2016, 02:08 AM
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:"?