How to extarct value of parameter from given string

sgnarkhede2016

Hello,

我有一个字符串“AGGRGATION_PERIODICITY=DAILY|DIRECTION=OUTWARD|FINANCIAL_PRODUCT=REMITTANCE" want to extract "DAILY" and
store into new attribute PARAM_PERIODICITY

How can i do this

Thanks in Advance

BalazsBarany

Hi!

I would use Generate Attributes with a formula likereplaceAll( 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

sgnarkhede2016

using generate extract I resolved this