Parse data to determine page and extract data

[ricky10ss]

Attached is a sample data file with Slot1 - Slot68. Each slot could be a voucher or Coupon. The attached image shows what they are trying to do. The first character determines if the page selected is a coupon, voucher or blank. If a voucher then the next three character are the voucher number like SLOT35 in the sample data V203.

 

If a coupon then the 2-3 character is the coupon code, 4-5 is the Service Type code, 6-11 in the mileage, and 12-15 is the value. Would need to parse each out to include the data into the coupon.

 

Anyone have an idea on how to parse this out via Javascript? I could then turn on and off pages based on the it being a coupon, what version of coupon and/or if blank.

Sample_Data.txt

[step]

You could use the substr method to parse the values from your string:

// Your field here.
var field = Field('SLOT1');
var type = field.substr(0, 1);
switch (type) {
 case 'V':
   var code = field.substr(1, 3);
   break;
 case 'C':
   var code = field.substr(1, 2);
   var serviceCode = field.substr(3, 2);
   var mileage = field.substr(5, 6);
   var value = field.substr(11, 4);
   break;
}

Alternatively, you could use regular expressions to match the pattern:

// Your field here.
var field = Field('SLOT1');
var [type, code, serviceCode, mileage, value] = (field.match(/^(.)(.{2,3})(.{2})?(.{6})?(.{4})?$/) || [,'B']).slice(1);

[ricky10ss]

Thanks Ste. I was going to use a OnRecordStart rule that turns on the correct pages for the slots see example below. To use the parsed data in your example on each page do I need to create a rule for each field and data set I am trying to use? If I want to use Slot2 and value. Do I have to create a rule Slot2CouponValue? and Slot2CouponMileage for the mileage for Slot2?

 

if (Field("SLOT1") != "")

{

FusionPro.Composition.SetBodyPageUsage("1",true) ;

FusionPro.Composition.SetBodyPageUsage("2",true) ;

 

}

 

if (Field("SLOT2") != "")

{

FusionPro.Composition.SetBodyPageUsage("1",true) ;

FusionPro.Composition.SetBodyPageUsage("2",true) ;

}

 

if (Field("SLOT3") != "")

{

FusionPro.Composition.SetBodyPageUsage("1",true) ;

FusionPro.Composition.SetBodyPageUsage("2",true) ;

FusionPro.Composition.SetBodyPageUsage("3",true) ;

FusionPro.Composition.SetBodyPageUsage("4",true) ;

}

if (Field("SLOT4") != "")

{

FusionPro.Composition.SetBodyPageUsage("1",true) ;

FusionPro.Composition.SetBodyPageUsage("2",true) ;

FusionPro.Composition.SetBodyPageUsage("3",true) ;

FusionPro.Composition.SetBodyPageUsage("4",true) ;

}

else

return "";