Consulting

Results 1 to 2 of 2

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

  1. #1
    VBAX Newbie
    Joined
    Jan 2016
    Posts
    5
    Location

    Exclamation 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.

  2. #2
    VBAX Regular
    Joined
    Mar 2012
    Posts
    32
    Location
    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
  •