Extract Part of a field using a formula

[Acer1608]

Hi
I'm trying to extract certain numbers from a database field and use them as a formula to filter off.

The field would look like this normally .. 55-050-325-150


Basically I want to be able to pull the 0-325 digits out of the field.

Ive been trying to use the Left and Instr but not having much luck.

 

[Turkbear]

Hi,
If that pattern is always the same then:

MID({Table.StringField},6,5)

should do it.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[swiss2007]

if {Command.abc} like "*0-325*" then true else false

 

[swiss2007]

sorry, I meant
if {Table.yourstringfield} like "*0-325*" then true else false