Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
how to filter out rows in exampleset by an attribution in these rows containing regular expression
Lei
I have a dataset. I want ot filter some rows when the rows match a condition.
For example, the dataset as follow:
word value
rain/C 39
sunny 20
snow/d 10
wind/G 27
cloud 50
I want to filter out some rows, in which word contains letter "/C" or "/G". In fact, the condition should be any "/" + one uppercase letter.
(It is good to use regular experssion to give condition. So I can change based on different requirement)
So the result above should be like:
word value
sunny 20
snow/d 10
cloud 50
Is there anyone who can help me?
Thank you very much.
Find more posts tagged with
AI Studio
Operators
Accepted answers
Caperez
Hi
@Lei
,
In this case you can use a regular expression like this ["/]\w
please find attached an example.
Best,
Cesar
regex.rmp
All comments
Caperez
Hi
@Lei
,
In this case you can use a regular expression like this ["/]\w
please find attached an example.
Best,
Cesar
regex.rmp
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups