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, 201015 yr by Guest

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?

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.