Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
How to extarct value of parameter from given string
sgnarkhede2016
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
Find more posts tagged with
AI Studio
Accepted answers
All comments
BalazsBaranyRM
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
using generate extract I resolved this
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups