Split string to two equal parts

[YasserKhalil]

Hello experts
I have devised code that calculate the length of string and then split it into two equal parts ..

Please Login or Register  to view this content.

But I need to skip special characters and numbers and spaces (if found at the split point)

For example :
str = "Hi This is for test "", ! 123 How are you?"

Would be splitted into two parts:
---------------------------

Please Login or Register  to view this content.

Please Login or Register  to view this content.

In this case I would split the string to be like that

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope it is clear
Thanks advanced for any help

[zbor]

Please Login or Register  to view this content.

has 15 letters

Please Login or Register  to view this content.

has 9 letters

How is that a half?

[YasserKhalil]

Thanks for reply ..
I have mentioned that it works well for me (the code I attached is working as expected and split the string into two parts)
But my request is to skip the special characters and spaces and numbers if found at the split point
In the example : the split point was at the space after the word "test" but I don't need space , nor quotation marks nor numbers nor exclamation mark nor comma ..
so I don't need equal parts exactly .. but after equal skip special characters

[karedog]

Maybe :

Please Login or Register  to view this content.

[YasserKhalil]

Mr. Karedog
Thanks a lot for your wonderful help .. That's really awesome ..
I don't know anything about VBScript.RegExp .. searched a lot but can't get it ..Is there a beginner source for learning this part?

Can it be converted to UDF as I would deal with more strings in various subroutines?
Best Regards

[karedog]

You are welcome, thanks for marking it solved and for the rep. points.

I am still learning the regex too, it is quite hard for me because we are forced to memorize the syntax for every single rules exists (and I don't like to memorize things )
Usually I come to these sites for reference :
http://www.regular-expressions.info/vbscript.html
http://stackoverflow.com/questions/2...cell-and-loops

And of course, as usual, google is our best friend, searching using keywords like "vbscript regex tutorial", we will get many.

Regards

[YasserKhalil]

Thank you very much for the links..
If it was hard for you to learn or memorize it .. so it would be impossible for me to learn even the essentials

Can the code presented from you be converted to UDF as I would deal with more strings in various subroutines?

[karedog]

Miss the request for UDF :

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very very much for this incredible help
You are my Champ

[karedog]

If it was hard for you to learn or memorize it .. so it would be impossible for me to learn even the essentials

Not really. I remember when I was in elementary school, my friends can do very quick math multiplication, because they remember every shortcut for every base number, for example quadrat number ending with 5 (like 15,25,35), the shortcut is take the first number then multiply this number with (number + 1), then follow by 25, like :
15x15 = 1 x (1 + 1) followed by 25 --> 225
25x25 = 2 x (2 + 1) followed by 25 --> 625
People with good memory, can remember all the shortcuts and make they calculate faster using the shortcuts.

So if someone keen enough to remember all the rules including the examples that use the rules, I think he will be good at regex.

[karedog]

You are welcome, it's my pleasure.


Regards

[YasserKhalil]

Thank you very much Mr. Karedog
I had made use of your function in this link
http://chandoo.org/forum/threads/vba...formula.15957/