Split string variable by specific pattern

Hello everyone
I have a string variable (from a text file) which I need to split by specific pattern ..
The pattern would be space followed by numeric values then the symbol ) like that

Please Login or Register  to view this content.

So how can I split by this pattern
Example:
input = 1) any data 2) some other data 3)other data 4)and so on ...
Output would be
1) any data
2) some other data
3)other data
4)and so on ...

Thanks advanced for help

Hi Yasser, try this code :

Please Login or Register  to view this content.

Thank you very much my friend. You are awesome and brilliant
Best and Kind Regards

You are welcome, glad I can help.

Regards

Thanks a lot
I have posted similar thread here to import from text files ..
http://www.eileenslounge.com/viewtopic.php?f=30&t=29716

It is working well and I can import from text files .. BUT
There is a problem when trying to my text files which are in Arabic

Any idea how to fix that?

Here are the files (one is OK which in ANSI and the other which UTF-8 is not OK)
and here's the code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That's wonderful ..
Now the text file "Problem Text File.txt" solved and the other ANSI text file has the problem .. It seems that there must be a switch but I don't know how to check ANSI and UTF-8 ?

I have changed the code on post #7.

Then you must change this line from Sub Loop_Through_Text_Files() :

Please Login or Register  to view this content.

Thank you very much for this wonderful UDF. That solved the problem of UTF-8 and ANSI point
Thanks a lot my friend

One last point and I promise not to ask more here ..
Have a look at the following text file ... for number 3) :: there are multiple lines .. How during the import of the text file keep those lines (exactly as using Chr(10) in VBA)

Change to :

Please Login or Register  to view this content.

Thank you very much
Now there's an empty row after the title of the text file .. It didn't exist before ..How can I get rid of it? I tried but I didn't succeed ..

This should do everything :

Please Login or Register  to view this content.

You are AMAZING. Thank you very much my friend for great and incredible help
Best and Kind Regards

You are welcome, glad to help.

Regards

Hello again
How to edit this pattern

Please Login or Register  to view this content.

To allow using bracket ) or hyphen - or asterisk * .. Any of these three symbols may be followed by space and may be not followed by space

Should be :

Please Login or Register  to view this content.

Thanks a lot my friend
I am trying to learn how to build a pattern
Here's a pattern of one of the files

Please Login or Register  to view this content.

It is working well .. but how to exclude empty lines from results?

I don't understand what you asking. Is this a new case (different data file and pattern from post #1 - #17) ?

Yes this is a different pattern .. I could play with it because of you .. I have learned a lot from you
Just I noticed empty lines and if there is an easy way to exclude them but if not, don't worry about it

Even if this could be done using single pattern, it could be not an easy one, would be better done using 2 different patterns.
Can you post a sample data, before and after ?

Here's simple sample to illustrate the issue
Untitled.png
the red rectangles are empty lines which are not desired

I attach excel and the data files, included previous files

Believe me .. You're amazing and brilliant
Thank you very very very much. Thanks a lot for all great help
Have a nice time my friend

Thank you, glad to help.

Regards