 |  |
Norris Sydnor wrote:
Re: Importing Customers
From: Shawn Hogan
Date: Monday, October 12, 1998
Time: 4:50:35 pm
>Does anyone know how to take a field in an Access Database and convert it
>into 4 separate fields. We need to do this in order to get our data into
>Optigold. I have the slightest idea how to write a formula or function in
>Access to do this.
>
>Please reply directly.
Okay... I'll give you an example of how you can do it automatically with
Optigold and it's Replace function...
Import Credit Card Number to Credit Card Number 1 and the expiration date
to Credit Card Exp Date 1
If you use the specify calculation of the replace function (check the
manual index for info on the replace function), you can use the following
formulas (in this order) to do it:
-----------
Credit Card Number 4 = "Middle(Credit Card Number 1, If(Length(Credit
Card Number 1) = 16, 13, 11), 99)"
Credit Card Number 3 = "Middle(Credit Card Number 1, If(Length(Credit
Card Number 1) = 16, 9, 8), If(Length(Credit Card Number 1) = 16, 4, 3))"
Credit Card Number 2 = "Middle(Credit Card Number 1, 5, If(Length(Credit
Card Number 1) = 16, 4, 3))"
Credit Card Number 1 = "Left(Credit Card Number 1, 4)"
Credit Card Exp Date 2 = "Right("00" & Right(Credit Card Exp Date 1, 2),
2)"
Credit Card Exp Date 1 = "Right("00" & Left(Credit Card Exp Date 1, 2),
2)"
-----------
That's just off the top of my head, so I would definately back it up
before you do it. :-)
But that should work fine. (That's also assuming your exp date in Access
is in a MMYY format.)
- Shawn
-------------------------------
Shawn D. Hogan
President, Data Point Solutions
http://www.data-point.com
(619) 452-3696
ICQ: 8319647
Messages In This Thread:
Return to Digital Point Solutions' Home Page