regex

Dear All, I have a large sheet that does contain usage date of telephone numbers. To uniform all numbers to an normalized format so I need to replace nrs starting with 56xx to nr 852392556xx There are many more changes that I need to make so I use a macro for this that does all the...

I need help generating a regular expression that does not match a certain form of string. The string can be: -K09+M72+L86+B12 . . . Or even K09 + M72 +L86 + B12 But cannot be: -K098+M72+L86+B12 -kshbd+M72+L86+B12 -K98+M72+Ldsjfjhb86+B12 -etc. Right now I have...

I have a string and a pattern. If a substring of the string is found in the pattern, the string is no longer valid. I would like to return a message stating which substring was found in the pattern. I appreciate any help. String: K22+L09+P88+Q12+J56 Pattern: (N75|X02|A21|U67|L09|...) Output...

I desperately need a pro to help me deal with some regular expressions and lookaheads. I'm really not sure what the problem is with my code, but when I tell it to search through and see if, say for example, U55 is in the row it returns True when it should be False. All criteria in a row must be...

I need help creating a function to compare strings; probably using regular expressions since it is a bit tricky. We have six strings: String 1: "V06+K73+U55+M67" String 2: "!M43" String 3: "!U67" String 4: "V06" String 5: "" String 6: "" In this case, "!" means 'not' so this statement would...

Hello everyone, I have been working on a project for a while now and I am near the end, but I have hit a few walls. I do have a few problems, but I will begin with the one I believe to be the simplest. I have two sheets with data. One sheet has a "MLFB" number and option codes. These are...

Hi there, I have an Excel file with several cells containing text. The text contains some codes and I would like to know whether it's possible to lock those codes (by means of some formula or VBA macro, for example). The aim is that any text contained in the cell can be modified except those...

I'd like to refer to this post for a better understanding of what I'm trying to do http://www.mrexcel.com/forum/excel-questions/613012-visual-basic-applications-parsing-webpage-specific-value-between-tags.html I need help trying to extract specific values between tags from a list of websites...

I'd like to know how to do a search and replace by checking each cell in a given column against an array of values provided by the user. Specifically, I have a user that needs to find several (but not all) model numbers with the format of "\b([0-9]?[A-Z]{2,3}).*" and add letters to the end of...

Hi all, Is there any solution to do this task? I have been searching for solution, but i did not found it. I am using this code for replaces. But dont know, how to say the script, that $2 i want to replace with small case For example elefant 1234AB to elefant 1234ab I know i can do it also...

Hi, I need to extract data a substring form a string matching tree letter followed by a space and then three numbers; XYZ 123. But sometimes it can be surrounded by other text, sometimes not. Some times it doesn't even exist on the row. What's the best solution of matching this? I was thinking...

I am trying to figure out how to keep only a part of a string. The part I want to keep is marked with capitals in the example below. Example of cell contents: [something between brackets, like this]something else, belonging to the, same occurrence, PART OF INTEREST;[a new occurrence]with, a...

Can somebody give me a regular expression to do an approximate, atleast 3 letter match between two words. For example I have "Alex Mike" in one column and "mAlex" in another. There is a space in between Alex and Mike and we are comparing to mAlex. I think its tricky. I tried using the...

I'm using Google PPC to promote some live training events. I have a database full of upcoming event titles. I need to build dynamic ads using these title values as well as some other parameters. Google gives you 2 description fields to populate both with a character limit of 35 each. Many of...

Hi People I have searched a _lot_ for this solution, but I do not know how to do it in VBA. I want to be able to call a function in the following way: MsgBox RegExp("abc123def456", "a(.+?)def(.+?)6", "$1Hello$2") And for that to return: bc123Hello45 I have found many regex functions, but...

Someone...I know someone...is bound to say it's bad practice to make a function declared as a particular variable type should remain that same variable type and is bad coding to do otherwise. However, I am curious if there is a way to do so... The scenario is this: I created a RegEx function...

Hey all, I have two names like this: PRIMEAU,I & PRIMEAU,JANETTE BAIN ED & HELEN which are similar but different than the following: AVERNA,ROBERT C Corn,Marlin Lizand,ROBERT H CATANESE,SALVATORE J & OLGA M JIMENEZ,ALEJANDRO & HILDA M Hernara,Harry & Marie Anne Martin White,Alex & John M...

I can afford the £200 regex expansion for a simple job, and then have hassle of distributing that. I need to turn: fooTest1234foo into -> Test1234 and things like foofoo123Test23foofoo into -> Test23 So that's a del,! and [0-9]. But the [0-9] number could be any length of digits. I...