Middle Calculation

[Richard Corso]

I have a portal called cash out, and one of the fields is for a visa gift card number. We use a card swipe to enter the number. I used

Middle (GiftCardNum; Position (GiftCardNum; ";"; 1; 1) + 1; Position (GiftCardNum; "="; 1; 1)-2)

to capture the number. This has been working just fine, until I added a field above the portal to enter the customer ID number to create a new cash out. Now when I swipe the gift card the number will not go in to the GiftCardNum field. The field is blank and a different set of numbers are put in the field above the portal.

When gift card is swiped:

%B4793470269250179^GIFT/CARD^1104121100000001000000433000000?

;4793470269250179=1104121100000001433?

The number that I need:

%B4793470269250179^GIFT/CARD^1104121100000001000000433000000?

;[color:red]4793470269250179=1104121100000001433?

The calculation in the field:

Middle (GiftCardNum; Position (GiftCardNum; ";"; 1; 1) + 1; Position (GiftCardNum; "="; 1; 1)-2)

The number that used to go into the GiftCardNum field:

[color:red]4793470269250179

The number that now is captured and sent to the field above the portal:

;4793470269250179=1104121100000001433?

If I delete the field above the portal, every thing works just fine. I would really like to keep the field above the portal to enter the ID number in. Any suggestions.

Edited February 2, 2010 by Guest

[Fitch]

The last paragraph of your post is the key. Sounds like the problem is not your calculation, but something to do with field behavior settings and/or perhaps you have a script involved here?

[Richard Corso]

Found it, it was the giving the new field a tab number. When I deleted the tab number it works fine.

Thanks for the reply.