Formula to look at a certain digit in text

Hello,

I'm building location labels and would like a formula to place an arrow pointing up or down based on the second segment of the location number.


locations are formatted like: A5-01-01
the second segment of that text defies the rack level, they are 01, 02, or 03.

I want it something along these lines:
if second segment is 01 then down else up



Thank you,
Bas

If the location will always be formatted with "-" between the sections, try something like this:

NumberVar at = inStr({MyTable.Location}, '-');

if at > 0 then

  if mid({MyTable.Location}, at + 1, 2) = '01' then

    chr(226)

  else chr(225)

When you put this formula on your report, change the font to WingDings and you'll get the appropriate up or down arrow.

-Dell