Using wildcards to find number in a sentence

[marysilvaramos]

Hi:

I should find the position of a number in a sentence and later extracted. The number is attached always to an "E". ie: E1, E2, E3,E4. The range of the number is 1-4. I have this until now:

X: InStr("E[#]",[Col1_Comment_1])

but it always return 0

Please, may you tell me where is the error?

Big thanks in advance,

Mary

 

[John Big Booty]

I don't believe that the Instr() function will accept wild cards. You could use a loop, perhaps something along the lines of;

Dim srchStr As String
Dim I As Integer

For I = 1 to 4
     srchStr = "E" & I
          
          If Instr( srchStr, [Col1_Comment_1]) > 0 Then
               MsgBox " You have a match" [COLOR="Green"]'Replace with your action[/COLOR]
          End If
Next

 

[marysilvaramos]

Thanks John for the reply! Is there anyway to find the number in a query? I am using a query to get the value and use it in a formula.

Thanks

Mary

 

[John Big Booty]

Given that you only have four combinations could you test for all four explicitly?

 

[Galaxiom]

This expression returns the next character after the first letter E in the textfield.

Mid([textfield],Instr([textfield],"E") + 1, 1)

Limit the query to records where the digits 1 to 4 following an E by using this Where clause.

WHERE [textfield] Like "*E[1-4]*"

 

[marysilvaramos]

Thanks to both for the replies! I am testing both versions.

Thanks again for the help,

Mary