How to replace multiple column/field names with a `(` with an `_` underscore

[HattrickNZ]

I have a search that gives me a number of columns in the stats field.

max(col1) max(col2) ...
1 2
...

Can I replace the brackets in the column/field names with underscore?

max_col1_ max_col2_ ...
1 2
...

I have looked at replace but that seems to work on the values in the field as opposed to the fieldname.
I am looking for a generic way to do it as apposed to go through each field.

[somesoni2]

You can use the rename command with wildcard.

your current search giving column names max(col1) max(col2)... etc | rename max(*) as max_*

[somesoni2]

@MuS's solution is what the most optimum and recommended one (get the correct column name while generating columns).

[MuS]

Hi HattrickNZ,

in your stats command you can provide names for the result:

 your base search here | stats max(col1) AS max_col1 max(col2) AS max_col2  

Hope this helps ...

cheers, MuS

[HattrickNZ]

tks Mus, sorry should have said, was looking for a more generic way. I am familliar with that method.

[MuS]

I reckon you should rephrase your question in this case; so we understand what you're looking for and also provide your search string.