How to extarct value of parameter from given string

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 2024 in Community Q&A
Hello,

I have a string "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
Tagged:

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Hi!

    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
  • sgnarkhede2016
    sgnarkhede2016 New Altair Community Member
    using generate extract I resolved this

Categories