The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

How to extarct value of parameter from given string

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
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

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    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
  • Options
    sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
    using generate extract I resolved this
Sign In or Register to comment.