An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
I have a string "AGGRGATION_PERIODICITY=DAILY|DIRECTION=OUTWARD|FINANCIAL_PRODUCT=REMITTANCE" want to extract "DAILY" and store into new attribute PARAM_PERIODICITY
I would use Generate Attributes with a formula like replaceAll( attribute, ".+PERIODICITY=(.+)\\|DIRECTION.+", "$1") .
The regular expression searches for the appropriate string. If the format varies (e. g. DIRECTION is not always on the same place), you need to change the regular expression.
I would use Generate Attributes with a formula like replaceAll( attribute, ".+PERIODICITY=(.+)\\|DIRECTION.+", "$1") .
The regular expression searches for the appropriate string. If the format varies (e. g. DIRECTION is not always on the same place), you need to change the regular expression.
Regards,
Balázs