Formatting string formula 2

[Buckaroo8]

Hi All,
I have a field which contains strings of letters and/or numbers:
Examples: Hospital-Unit-Room-BedNum or Hospital-Department
Hospital-ICU-1234-1
Hospital-ICU-1234-2
Hospital-TELE-4567-A
Hospital-TELE-4567-A
Hospital-Laboratory

What I need is to have only the last six characters display IF there are numbers in the string - Right({table.field},6)?
AND
if the string has no numbers, display the entire string - Hospital-Department.

Thanks for All Help!

 

[-cush-]

if left(Right({table.field},6)) in [0,1,2,3,4,5,6,7,8,9] then
Right({table.field},6)
else
{table.field}

 

[-cush-]

Here is the debugged version:

if left(Right({table.field},6),1) in ["0","1","2","3","4","5","6","7","8","9"] then
Right({table.field},6)
else
{table.field}

 

[synapsevampire]

Try:

if isnumber(Right({table.field},1) then
Right({table.field},6)
else
{table.field}

This assumes that if the last character is a number, then all 5 of the 6 characters are.

You could also use a version of kcushing's post to do check the other side:

if isnumber(left(Right({table.field},6),1)
and
isnumber(Right({table.field},1)) then
Right({table.field},6)
else
{table.field}

Otherwise you'd have to loop through the string.

-k

 

[bdreed35]

Try this:

stringVar array strRight := split(right({table.field},6),"-");

if isnumeric(strRight[1]) or isnumeric(strRight [ubound(strRight)]) then 
    right(strRight,6)
else
    strRight

~Brian

 

[Buckaroo8]

Thank you all for your solutions!!!