Organize fields transformation resets after changing variables

[ldrascic]

Hi @ianhud,
If {_start="YYYY-MM-DD"} is part of the column name then try using grafana transformation Rename by regex with:

Match: (.*)\s{.*
Replace: $1

This regex should extract anything that’s before bracket {. So from:

_value {_start="2023-02-18 16:12"}
Device {_start="2023-02-18 16:12"}
Type {_start="2023-02-18 16:12"}
_field {_start="2023-02-18 16:12"}
_measurement {_start="2023-02-18 16:12"}

You would get:

_value
Device
Type 
_field 
_measurement 

You can try this on www.regex101.com with flavor Golang. Here is a direct link with filled data and regex:

• Regex101 | data and regex

 

You can also take a look at this post for more information:

Can you extract a word from within a tag to automatically label the legend?

Hi @ppxtb, In Transform tab (near Query) you can choose Rename by regex and for Match enter: .*\(([^\)]+).* and leave Replace as $1. [Grafana regex] Regex breakdown: .* - means any symbol 0 or more times (basically means match anything) \( - specifies that after anything there must be a literal symbol ( ( - starts matching group [^)]+ - means match anything until you find ) symbol ) - closes matching group .* - matches anything till the end Replace breakdown $1 - means return wha…

 

Best regards,
ldrascic