+ Reply to Thread
Results 1 to 5 of 5

RegEx pattern, code exacuting but doing nothing

  1. #1
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    RegEx pattern, code exacuting but doing nothing

    Very new to RegEx I have data in cells like this

    Col A
    stuf 22-9989
    stuff 559-6629
    ...
    .
    .
    .
    sfuff 1-66300

    I want

    Col A
    stuf 22.9989
    stuff 559.6629
    ...
    .
    .
    .
    sfuff 1.66300

    My code is exacuting but doing nothing

    Thanks

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: RegEx pattern, code exacuting but doing nothing

    You should be getting an error since X here is a 2D array:
    Please Login or Register  to view this content.
    so you need:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: RegEx pattern, code exacuting but doing nothing

    The pattern is more like

    Please Login or Register  to view this content.
    You also need to include the case insensevity
    Last edited by AB33; 01-23-2015 at 01:36 PM.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: RegEx pattern, code exacuting but doing nothing

    1)
    Please Login or Register  to view this content.
    2)
    Please Login or Register  to view this content.
    But why not just
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-11-2010
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: RegEx pattern, code exacuting but doing nothing

    Thank you romperstomper

    Thank you AB33

    Thank you jindon, no reason other then tring somthing new (RegEx looks helpful)

+ 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. Regex: Matching pattern to split a cell data
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-01-2014, 07:31 AM
  2. Regex - establishing a pattern
    By twckfa16 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-30-2014, 11:06 AM
  3. [SOLVED] RegEx pattern to extract multiplelines title in TXT file
    By p24leclerc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 08:39 PM
  4. Not able to use the regex in code...
    By lifeankit in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2014, 06:54 AM
  5. 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

Tags for this Thread

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