wild card

iuphim

Registered User.
Local time
Yesterday, 20:59
Joined
Oct 30, 2008
Messages
43
I want to wild card anything that's in a parenthesis that doesn't fall in this format of ( number / alpha).

Can anyone help?

Thanks!
 
Can you be more specific.. where do you want this done?
 
Need a lot more detail. However here is a taste to get started.

This one tests for a number to the left of a slash.
IsNumeric(Left({expression},Instr({expression},"/")-1))

You will be setting up this in a function I expect as an expression in a query will likely become very unweildy.
 

Users who are viewing this thread

Back
Top Bottom