Search Again: Re: - Question From: Shawn Hogan Date: Friday, August 3, 2001 Time: 2:48:32 pm Michael J. Colvin wrote: > When I originally imported a butt load of users from an access database, > the CC Numbers all had the leading "0"'s truncated on the expire dates > month....Now, when I run Bill Customers, those cards result in a Plug In > Error because of the invalid date... > > Any suggestions on how I can search for the lack of a "0" in the month > field? Go into Find mode... search for "1...9" in that field without the quotes and omit them. Although it would totally be cosmetic anyway, as the system will take it into account for you. Actually, I have a better idea... don't search for them, just do a replace with a calculated result to fix them all (and leave the ones that don't need to be fixed alone). Use the calculation: If (IsEmpty (Credit Card Exp Date 1), "", Right ("00" & Credit Card Exp Date 1, 2)) - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: - Question by Michael J. Colvin on Aug 3, 2001 at 2:28:28 pm Re: - Question by Joseph Smith on Aug 3, 2001 at 2:43:06 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 2:48:32 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 5:14:20 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 5:18:59 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 5:25:39 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 6:25:34 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:05:03 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 7:17:12 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:24:53 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 7:38:09 pm Re: - Question by Shawn Hogan on Aug 3, 2001 at 7:40:14 pm Re: - Question by Michael J. Colvin on Aug 3, 2001 at 8:47:18 pm