RegEx run time error! what is the wrong in the Pattern?

[exceere]

Hello, the following function used for find and replace non-ascii whole string

When i run the function i get run-time error 5017 Application-defined of object-defined. The error due to the positive lookbehind (?<=), but what is the wrong in syntax?

Please Login or Register  to view this content.

[jindon]

Regular Expressions in vba doesn't have that functionality.

[exceere]

is ther an alternative to get the same fanctionality?

[jindon]

Please Login or Register  to view this content.

[exceere]

Yes, your simple solution solved the issue. YOU ARE GREATE.

but, what does "$1" means?

Thank you?

[jindon]

Do you understand the meaning of your original pattern?

[exceere]

Yes. Does $1 means restore the first letter in the match?

[jindon]

Refers to character(s) in first set of brackets.

[exceere]

Thanks.

After i started test it, i notice the Pattern didn't match words at the beginning and end of the string.

Please Login or Register  to view this content.

Result:
"Book Jonny Car Book"

it didn't replace "Book" at beginning and "Book" at the end!

How can i change the pattern to match, also, words at beginning and end?

[jindon]

What is your desire result?

[jindon]

So, you are using the pattern that you have.

Please Login or Register  to view this content.

[exceere]

Thank you.

Desired Result: "Car Jonny Car Car"

i used the function to replace arabic words, so \b dosn't work for me.
Example:

"كتاب جوني كتاب كتاب"

i used english example just for simplify.

so, desired result in Arabic:
"سيارة جوني سيارة سيارة"

Thanks

[jindon]

Then change the pattern to

Please Login or Register  to view this content.

[exceere]

Yes, Your are great jindon.

I appreciate your valuable time and effort

[exceere]

Hello,

Now, how can i replace (), {}, [],<>.

I get an error when i replace using follwing sub:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[exceere]

Hello, Thank you

I think you mean

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Tank you very much jindon.


I appreciate your valuable time and effort.

[jindon]

And unnecessary extra "(" by accident...