RegEx pattern

Very new to RegEx,
I have in cells in a column like:

Please Login or Register  to view this content.

I want

Please Login or Register  to view this content.

I have tried patterns like:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Not getting it

Thanks

I am using it in VBA

I am using like this

Please Login or Register  to view this content.

Apologies about my sloppy question, I have cells like:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

There are more possibilities but all end with

Please Login or Register  to view this content.

What do you want to return or extract?

From the above

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I want to remove the

Please Login or Register  to view this content.

from the ends of all the strings in my range

Thanks

Hi..

Rather than using Regex and most probably a loop.. try this..

Please Login or Register  to view this content.

lol.. mm.. yeap.. I may have gone a bit overboard on that one..

Why RegExp?

Just replace ", Other (please specify)" with "" should do....

If you insist

Please Login or Register  to view this content.

Ah, I just remembered your thread.

http://www.excelforum.com/excel-prog...g-nothing.html

For the learning purpose...

You want to remove

Stuff, Other (please specify)

So the patter should be

"(, Other \(please specify\))"

You missed a space after "Other"...

Originally Posted by capson

I have in cells in a column like:

Please Login or Register  to view this content.

I want

Please Login or Register  to view this content.

As I mentioned already, you missed a space after "Other"

You need to replace "Other (please specify)"

Hi capson..

though I admit to being a bit lost on apo's solution

I will try to break it down for you so you might understand what i was thinking..

Note to anyone else: If any of the following (technically or terminology) is incorrect... please let me know..

First.. try stepping through this code.. its' basically the same as the 1 line of code but I have separated it so each line does a specific thing..

IMPORTANT.. make sure your "Locals" window is open.

In the VB Editor.. go to "View" and enable the "Locals" window.

Please Login or Register  to view this content.

You will see something like this..

Locals.png

Explanation:
a = Shows what the values would look lke when put into a 2 Dimensional array.

b = Transpose the values from the array into a 1 Dimensional array. This is so we can use the Join command next.

c = Join all the elements in the 1 Dimensional array (by the vbcrlf delimiter) into 1 long string.

d = Replace all instances of ", Other (please specify)" with "" in the long string.

e = Use the Split command (using the vbcrlf again as the delimter) to separate the lines into tseparate elements of a 1 Dimensional array.

f = Transpose it back to a 2 Dimensional array so it can written to the sheet correctly.

I hope that helps..

Wow, that helped a lot, I think I actually understood it!!!