Regex - establishing a pattern

Hello -

With regex, can you set the pattern based on number of digits in a string?

Here is the code I have so far:

The objective is to extract each character, if you find a pattern with 3, 4, 5 integers and a space, set it to your pattern.
If you find the pattern again, set it to new line.

Please Login or Register  to view this content.

The code is not complete and may be off but I will continue to research this.

A file is attached with desired result on bottom.

Thanks

I know basic of Reg expression, but if you want the pattern to start with numbers, I thought

Please Login or Register  to view this content.

Originally Posted by AB33

I know basic of Reg expression, but if you want the pattern to start with numbers, I thought

Please Login or Register  to view this content.

Better not post from your guess that is completely wrong.


twckfa16

If you lookif for the pattern which match to 3 to 5 degits numbers then

Please Login or Register  to view this content.

However, your code is not utilizing RegExp and even doesn't compile.

What are you trying to do?

I know it doesn't compile

For example, if you have the following strings in cells A1 and A2:

1443 some text here1444 plus 1 more test
1445 some text here 1446 plus (1 to 15)

You get the results in cells A3 thru A6(doesn't really matter):
1443 some text here
1444 plus 1 more test
1445 some text here
1446 plus (1 to 15)

Thank you

Output the results in col.B

Please Login or Register  to view this content.

Jindon - Thank you very much for what you supplied here. Got much further than I would have expected.

I noticed that when I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

...the output changes. is there a way to determine if they're are so many digits before a charater, pattern equals 3 or 4 etc.

Thank you again!

Not really sure what you are trying.
Perhaps.

Please Login or Register  to view this content.

I can try that. Basically, the three and four digit work good.
If you have 6 or 8 digits - they will need to be halved.

So if you have:

12345678nnn in one cell, that should be:

1234
5678nnn

Or if you have 123456, that should be
123
456

Is there something that can determine number of digits, and then change the pattern accordingly if you need to ?

Thanks

What about

12345xx

I havent encountered that yet but may need in the future.

I just saw one line with this pattern:

123sometexthere123sometexthere123sometexthere123sometexthere123sometexthere