Visidata: [wishlist] concatenate columns, value separator option

[aborruso]

In VisiData it's possible to concatenate columns, using & in Columns Sheet.

The results values will be separated by space. Then if your source columns contain already some space, it's impossible to have idea of the source distinction.

My request is to add a "value separator" option.

Thank you

[pigreco]

Just in these days I am using & to concatenate columns, it would be really useful to be able to choose a separator other than space

[saulpw]

This is no problem to implement. There are still a few design points to consider though:

1) What should the option be called?

2) Should this option (or a different option) be used for joining sheet names also? Both for JoinSheets and for diving into subsheets.

These may be different cases but I don't like having 3 or more different options. By default, column names and joined sheet names are combined with +, while other instances of combined sheet names are combined with _, and sometimes . is used instead. It would be nice to have these used and specified consistently.

[aborruso]

As usual you are very kind.

Thank you very much

[pigreco]

wow, thank you very much!

[aborruso]

@saulpw I have set value_joiner="|" in .visidatarc file, but when I do columns join I have always the standard value_joiner value, a white space.

If I set it via options sheet, it works.

I'm using saul.pw/VisiData v2.-4dev

[anjakefala]

Did you do options.value_joiner="|" @aborruso?

[aborruso]

Did you do options.value_joiner="|" @aborruso?

No, I'm stupid I wrote only value_joiner="|"

Thank you @anjakefala, it works