The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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
"[SOLVED] Replace operator: Use Regex in replace by attribute"
Contributor II
Hello everybody,
I have a small issue and hope someone can help me. I am trying to clean a data set comes from the aggregate operator. It has two columns, one with the name of the operator and the attribute, like "count(att1)" or "count(att10)" and one column containing the value of the operation.
I would like to rename the values in the first column from "count(att1)" to att1. I tried to play around with the replace operator but it did not work as expected, because I found no one way to use a regular expression in "replace by" just normal strings. Is there a way to work around this?
Thanks for any helpful hint
Figured it out on my own: I used a combination of two Replace operators - the first replaced "count(" by "" and the second replaced "(" by "". Problem solved
I have a small issue and hope someone can help me. I am trying to clean a data set comes from the aggregate operator. It has two columns, one with the name of the operator and the attribute, like "count(att1)" or "count(att10)" and one column containing the value of the operation.
I would like to rename the values in the first column from "count(att1)" to att1. I tried to play around with the replace operator but it did not work as expected, because I found no one way to use a regular expression in "replace by" just normal strings. Is there a way to work around this?
Thanks for any helpful hint
Figured it out on my own: I used a combination of two Replace operators - the first replaced "count(" by "" and the second replaced "(" by "". Problem solved
Tagged:
0
