Originally posted by: BNP

I am hopping someone can help me. Currently We have a data element that contains various information separated by a # (pound sign). However the data really could be looked at as a Key value pair. to extract data to load a column we use the WORD function to locate the xth element and then the Word function to grab the value. I am wondering if anyone knows how I could change the code so that I don't have to rely on the location of the element but find the data based on the Key value.
This is what the data currently looks like:
activeSubscriberCount=1#macIDStatus=#billCycle=15#billLanguageCode=#commitStartDate=#cycleCloseDate=#cycleStartDate=#dealerCode=#ivrNegative=false#ivrSubAllowance=false#lastPaymentDate=2009-09-23#paymentAmount=53.40#pinInd=true#subMarket=CVY#summarybillind=false#zipCode=20170#amountUntilLimit=#aslBalance=#aslLastActivity=#banSpendingLimit=150.00#collectionEndDate=#collectionStartDate=#collectionStatusCode=#lastBillDueDate=2009-11-01#unbilledAdjustments=0.00#unbilledCharges=0.00#unbilledUsage=0.00#affiliateSubscriberCsaInd=true#lineType=S#portOutInd=false#pricePlanCode=987654321#splitBillInd=P#status=R#deviceActivationDate=2008-01-01#serialType=E#subsDealerCode=123411234#splitBillCode=P#socCodePP=#namePP=#recurringChargePP=#multiTierPlan=F#ffPlanType=#addPlanTypeDescPP=#ppStartDate=#socType=#technologyCode=#iccId=#prePayInd=N#startDate=2010-11-23#commitEndDate=2015-07-26#lastActivityDate=2012-04-26#lastCollectionActivityCode=#subscriberId=9547292#activationDate=2011-01-01#contractRemainingMonths=12

So for example if I want to pull the billCycle value which is the third key value pair I do this:
=WORD(WORD(Last_calldata:PostRoute:File VariableData:Out, "#", 3),"=",2)

I would liek to just be able to find billCycle and grab the data after the '=' and befor the next #
any help wil be appreciated
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Try this:

IF(FIND("billCycle=", Field:In) > 0,
WORD(MID(Field:In, FIND("billCycle=", Field:In)+11, 30), "#", 1))

Thanks,
Phil
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: thorstenhirsch

You can also incorporate the field/value structure into your typetree, so that you can use this rule:

=LOOKUP(Value:Last_calldata:PostRoute:File VariableData:Out, Name:Last_calldata:PostRoute:File VariableData:Out = "billCycle")

Here you can see at once what the rule does.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: BNP

I like the idea of creating a type tree, could you possibly show me what the type tree definition would be fo
r the data I entered above?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer1

FileOfGroups - "#" sign delimited
....datagroups(s) - "=" delimited.
.......KeyField(1:1)
.......DataField(1:1)

LOOKUP(DataField, KeyField="BillCycle")

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender