Does anyone know how to pick the numbers out of a range field like this:
'>26 and <31' o
I've tried using the instring and mid functions but because the numbers in the range vary in size sometimes the formula field brings back the '>' or the part of the 'and' which i don't want. I thought about using nested if statements but i'm not sure where to start.
I'm using Crystal XI.
Any advice would be much apprciated
'>26 and <31' o
I've tried using the instring and mid functions but because the numbers in the range vary in size sometimes the formula field brings back the '>' or the part of the 'and' which i don't want. I thought about using nested if statements but i'm not sure where to start.
I'm using Crystal XI.
Any advice would be much apprciated