Supress left two chars

[ksaab2002]

hello,

I have a variable lenghth string. I need to supress the left two characters (IT) if the left three are = ITC...otherwise I need just to show the field.

I am stuck on the syntax..any suggestions?

Thank you,
K

 

[vidru]

If Left({Table.Field}, 3) = "ITC" Then
Mid({Table.Field},3)
Else
{Table.Field}

-dave

 

[gsomerville]

If uppercase(left({field},2))="IT" then mid({field},3) else {field}