Search Again: Re: - Question From: Michael J. Colvin Date: Friday, August 3, 2001 Time: 5:14:20 pm Enter that calculation directly in the CC Expire MONTH field? And that will replace the single digit months w/leading 0's, right? (Wanna make sure before I do it!) Mike > -----Original Message----- > From: isp-list@optigold.com [mailto:isp-list@optigold.com]On Behalf Of > Shawn Hogan > Sent: Friday, August 03, 2001 2:48 PM > To: Optigold ISP List > Subject: Re: [Optigold ISP] - Question >=20 >=20 > Michael J. Colvin wrote: >=20 > > When I originally imported a butt load of users from an=20 > access database, > > the CC Numbers all had the leading "0"'s truncated on the=20 > expire dates > > month....Now, when I run Bill Customers, those cards result=20 > in a Plug In > > Error because of the invalid date... > >=20 > > Any suggestions on how I can search for the lack of a "0"=20 > in the month > > field? >=20 > Go into Find mode... search for "1...9" in that field without=20 > the quotes and > omit them. Although it would totally be cosmetic anyway, as=20 > the system will > take it into account for you. >=20 > Actually, I have a better idea... don't search for them, just=20 > do a replace > with a calculated result to fix them all (and leave the ones=20 > that don't need > to be fixed alone). Use the calculation: >=20 > If (IsEmpty (Credit Card Exp Date 1), "", Right ("00" &=20 > Credit Card Exp Date > 1, 2)) >=20 > - Shawn >=20 > ------------------------------- > Shawn D. Hogan > President, Digital Point Solutions > http://www.digitalpoint.com > (858) 452-3696 >=20 >=20 > --------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.optigold.com/lists/isp.html > --------------------------------------------------- >=20 --------------------------------------------------- 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