Use Like or RE

[AlexanderBB]

I'm wanting to identify a string that starts with one char A to Z, then any number, than a period and space.

I *think* LIKE [A-Z][1-9]. *" could be be a starting point but I'm not sure if I'm getting confused with Regular expressions, plus how to handle a number > 9.

Thanks for any help

 

[Rick Rothstein]

I'm wanting to identify a string that starts with one char A to Z, then any number, than a period and space.

I *think* LIKE [A-Z][1-9]. *" could be be a starting point but I'm not sure if I'm getting confused with Regular expressions, plus how to handle a number > 9.

Thanks for any help

If your variable name is Code then try this...

If Code Like "[A-Z]" & String(Len(Code) - 3, "#") & ". " Then

 

[AlexanderBB]

Hi Rick,
I'm finding it fails if CODE has characters after ". "

 

[Rick Rothstein]

Hi Rick,
I'm finding it fails if CODE has characters after ". "

Sorry, I forgot you said "starts with"... we just need to add an asterisk (wildcard) at the end of the pattern...

If Code Like "[A-Z]" & String(Len(Code) - 3, "#") & ". *" Then

 

[AlexanderBB]

I did try that Rick, and still couldn't make it work here

? code
A1. This is a Test
? Code like "[A-Z]" & string(len(code)-3, "#") & ". *"
False

So I resorted to RE with

regex.Pattern = "^[A-Z][0-9]+\.\s"

 

[Rick Rothstein]

I did try that Rick, and still couldn't make it work here

? code
A1. This is a Test
? Code like "[A-Z]" & string(len(code)-3, "#") & ". *"
False

Sorry, my fault. Try your If..Then statement this way...

[table="width: 500"]
[tr]
	[td]If Split(Code, ". ")(0) Like "[A-Z]" & String(InStr(Code & ". ", ". ") - 2, "#") Then[/td]
[/tr]
[/table]

 

[AlexanderBB]

Hi Rick, that now works, but I found code = "AB. This is a Test" would also pass, when it should fail.

 

[Rick Rothstein]

Hi Rick, that now works, but I found code = "AB. This is a Test" would also pass, when it should fail.

That text string does not pass for me (using the code I posted in Message #6 ).