"[SOLVED] Replace operator: Use Regex in replace by attribute"
mataio
New Altair Community Member
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
0