Options

"[SOLVED] Replace operator: Use Regex in replace by attribute"

mataiomataio Member Posts: 6 Contributor II
edited June 2019 in Help
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
Tagged:
Sign In or Register to comment.