Find first character in a string

[stuhanna]

I'm trying to pass the cc type to a field based on the first character of the card # which is swiped into a temporary global field.

If the first character begins with "3" it equals amex, 4 = Visa, 5=MC and 6=Discover.

Can you help with the scripting - especially to find the first character. Thhanks in advance.

[Raybaudi]

Isn't this good for you ?

Case(

Left ( card # ; 1 ) = 3 ; "Amex" ;

Left ( card # ; 1 ) = 4 ; "Visa" ;

Left ( card # ; 1 ) = 5 ; "MC" ;

Left ( card # ; 1 ) = 6 ; "Discover"

)

Another way can be:

Choose ( Left ( card # ; 1 ) - 3 ; "Amex" ; "Visa" ; "MC" ; "Discover" )

[stuhanna]

This looks great and is very helpful. I'll give it a whirl and let you know.

Thanks!

[stuhanna]

[color:blue]Thanks...that was the trick!