Results 1 to 20 of 22

Thread: Find different expressions in same text (wildcard)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    VBAX Regular
    Joined
    Apr 2020
    Posts
    12
    Location
    It's a standard form with a lot of word cells, without patterns. There are about 20 cells and different information.
    I can copy all the form and paste without format.
    I understood Graham code, but i'm newbie in VBA and need now to understand how to extract string between two expressions.

    My current difficult yet is extract the name. I don't want to use MoveEndUntil to do this, because It will not be enough to extract adress, for exemple - because if I put "Do While .Execute("address:"): orng.Collapse 0: orng.MoveEndUntil "4"" and the address has a number 4, it will be a problem.

    After paste, without format, it's similar to this. It's not the real form, but it has the same method used in the real form.

    I – PERSONAL INFORMATION:

    1. Full name:
    2. ID: 3. SOCIAL INSURANCE NUMBER:
    4. Address: 4.1.Zip code:
    5. E-mail: 6. Phone number:
    7. Graduate:
    8. Previous job: ()
    8.1. Company name:


    II – DO YOU WANT TO ANSWER PROFISSIONAL REQUESTS? ( ) YES ( ) NO


    10. Is this your first job? ( ) YES ( ) NO
    Inform the date you started working: _____ /_____ / _____

    III – INFORMATION ABOUT HEALTH

    11. Type of previus disease:
    ( ) headache;
    ( ) bellyache;
    ( ) elbow;
    ( ) another.
    11.1. Describe syntoms:

    _________________________________________________________________________
    11.2. Name of hospital:

    _________________________________________________________________________ 11.3. Period:
    Date of sytoms started
    _____ /_____ / _____
    Date of syntonms end
    _____ /_____ / _____
    Last edited by Wandem; 04-11-2020 at 04:58 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •