November 11, 200817 yr 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.
November 12, 200817 yr 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" )
November 12, 200817 yr Author This looks great and is very helpful. I'll give it a whirl and let you know. Thanks!
Create an account or sign in to comment