regular expressions

  1. C

    Regular Expression - To match a closest space after nth character

    Hi, I'm trying to workout something and in need assistance on setting RegEx pattern. What would the regular expression pattern be if I were to match a certain space in a string. As an example, I have a string: "Mary had a little lamb" And I want to match the closest space to the left...
  2. D

    Replace " </p><p>" with new line using regular expressions

    I am trying to replace " " with a new line in visual basic using regular expressions. I tried to find: ([\s]*)("") and replace with: \n\n. However, in my text is replaced but with "\n\n", not two physical new lines. I also tried to replace it with \r\r, but it does the same.
  3. L

    Need help sorting a list of names in VBA to use in a combo box on a user form

    I've created a userform that allows people to enter their name, an item description and then they can choose two characteristics of their item based on combo boxes on the userform. I then built another userform to allow for finding previous entries and the user would search on the names that...
  4. J

    Regex in DAX language

    Hi, does anyone know if there is a possibility to use REGEX in DAX formulas? Many thanks for you help, Jakub
  5. J

    Data Collection Help

    I'm trying to build a sheet that collects addresses I receive from clients about available work throughout the US. This information comes to me via email from different clients. Each client sends me the information in a different format but all of them have the same information. The information...
  6. P

    RegExp in VBA

    Hi, I am trying to use RegExp in VBA to find all named ranges in a formula. To find it, I'm basically looking for a string that doesn't end with a ( and that is only made up of a-z, A-Z, 0-9, \, _. I'm a bit confused about atomic groups and look arounds. As far as I understand it...
  7. I

    Searching and replacing "- "

    I have a worksheet that contains 900 rows of text data. In the column some of the text starts with a hyphen and space "- ". The others start with a number or alphabets. I am trying to compare this column to another one and find matches between them using IF(ISERROR(MATCH. I followed the thread...
  8. E

    Regular Expression

    System.Text.RegularExpressions.Regex -->.Net Framework regular expressions Is it can be used in VBA?
  9. H

    Extract Data to another Column

    Is there a way to extract all values starting with aa, pt, ra or whatever multiple values starting with defined prefixes into another column. So if aa12345 as12345 root sys aa90231 are in column a I would like to move them into column F or possibly another worksheet. But I would need to...
  10. A

    rename file names using regular expressions

    greetings everyone, here's my situation, i'm trying to rename all the files, folders, subfolders, and also the files inside the subfolders in a path. The files/folders have "14" on their names. my trainer told me that it can be done using regular expressions, but i'm having a hard time...
  11. B

    Text Manipulation Puzzle

    I am given a spreadsheet with 1 column. In this column, is a long string containing a variable list of gps coordinates. The syntax of the string is always the same, like this: LINESTRING(lat lon, lat lon, lat lon) My problem is that I need to switch each coordinate to be lon lat instead of...
  12. J

    regex pattern not working in VBA

    Hey all, in this snippet of code: Set has_parens_with_content = CreateObject("VBScript.RegExp") With has_parens_with_content .MultiLine = False .Global = True .IgnoreCase = True .Pattern = "\([A-Za-z0-9]\)" If has_parens_with_content.test(clean_string)...
  13. D

    Regular expression pattern

    Can someone please advise what the correct pattern is to return the text between two search strings? For example, in the html string below, I want to return the text between "selected>" and "<". In this example I want "NA". "<SELECT class=nfinput name=pace0><OPTION value=L>L</OPTION><OPTION...
  14. M

    Regular Expressions: Named groups in VBA

    Hi, Is it possible to used named groups in VBAs version of Regular Expressions (Regexp) Example match groups for extracting dates from strings: (?:(\d{2})\.(\d{2})\.(\d{4})\s(\d{2}):(\d{2}):(\d{2}))|(?:(\d{4})-(\d{2})-(\d{2})\s(\d{2}):(\d{2}) will return DD.MM.YYYY or YYYY-MM-DD in submatch...
  15. J

    Use regular expressions to look for unicode words

    Hi, I'm trying to look for some whole-word Unicode words in a range of cells. My lookup words may look something like these: "an" "tiếp" "lị" "nguyễn", etc. (they are made up of characters from the Vietnamese alphabet) and my lookin cells may look something like these: "an" "ban, tiếp; lịn...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back