I'm working with fixed-with column and some of the values are variable-length strings (also having spaces) and they could be left or right-aligned.
In theory it is possible to come up with a regex trimming the unwanted spaces but in reality it is hard since the regexp becomes hard to maintain (and I have many of them)
Depending on the output format
- JSON - the values are NOT trimmed
- CSV - the values are trimmed
Would it make sense to trim the value in general? Our should/could this be a setting (global, field level)?