make NewFormulaColumn/Character more flexible

[hogi]

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

If columns with type "character" are selected, the New Formula Column menu shows the submenu character.
Among other option, there is the function concatenate which concatenates the strings.

There are also 2 more functions. They concatenate with Space or comma.

My wish:

• A more general function "concatenate with string ...".
  The idea: After selecting this function, a window pops up and asks the user to enter a string.
  Then one can concatenate also with "_" or "-" or ...

Contrary to what I wrote in a previous version of this post, "concatenate" is also available if characters AND numbers are selected.
If numbers are selected as well, a char(number) is added automatically. Cool
Unfortunately, the character/concatenate function is missing if all the selected columns are numbers.
Could you please make the concatenate function available also for this variant?

more wishes submitted by  

[Sarah-Sylvestre]

@hogi - Thank you for your suggestion! We have captured your request and will take it under consideration.

[hogi]

A workaraound can be found at: Col/Utilities/Combine Columns.

Most of the features are exactly matching:

- the user can specify the delimiter character

- the result column can be set  "multiple response"

- the function is also avalilable if all selected columns are "numbers"

The only disadvantage:
It generates the new colum by writing the values - i.e. not as a function.

Therefore, the table canot be used as a template and adding new data via tables/concatenate will not work.

[hogi]

new in JMP 17: concatenate with underscore  -> thanks

exactly the option that I wanted

backlog:

Unfortunately, the character/concatenate function is missing if all the selected columns are numbers.
Could you please make the character/concatenate functions available also if just numbers are selected?

[jthi]

Wish List item which was marked as Duplicate due to this wish list item which is a bit more wide in scope: Enable string concatenation in "New Formula Column" -> "Combine" for numerical columns