+ Reply to Thread
Results 1 to 3 of 3

how to Identify the correct pattern in Regex

  1. #1
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    319

    how to Identify the correct pattern in Regex

    Hello,


    I have the following pattern in Text file

    1.Loan A/c No. : 012568257844582 2.Cust Name : MADFD GRADHARAIA 3.Cust ID : 29382524 4.Sanc. Auth.: 001

    The Regex pattern "(\d+)\.(.+?) *: *(.+?)(?=( {3,}|\d+\.))" is identifying the first three fields only

    1.Loan A/c No. : 012568257844582 2.Cust Name : MADFD GRADHARAIA 3.Cust ID : 29382524

    What changes should be made in the above pattern to get the Fourth field also.


    Thank you

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,097

    Re: how to Identify the correct pattern in Regex

    Just for the line that you posted and assuming no further request.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    319

    Re: how to Identify the correct pattern in Regex

    Thank you for the assistance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Regex Pattern Matching
    By visualnotsobasic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-16-2018, 09:56 PM
  2. [SOLVED] Use inputbox and check regex pattern
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-30-2018, 01:44 PM
  3. RegEx - Pattern Matching
    By paularthur90 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2017, 09:16 AM
  4. Need to Define RegEx pattern
    By hmr2662 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2015, 09:24 AM
  5. RegEx pattern
    By capson in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 02-15-2015, 06:57 PM
  6. Regex - establishing a pattern
    By twckfa16 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-30-2014, 11:06 AM
  7. Need a new regex .pattern for comparison code
    By Swiss Cheese in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2012, 09:16 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1