regular expressions

  1. 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.
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. E

    Regular Expression

    System.Text.RegularExpressions.Regex -->.Net Framework regular expressions Is it can be used in VBA?
  8. 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...
  9. 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...
  10. 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...
  11. 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)...
  12. 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...
  13. 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...
  14. 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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top