cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Allow the Text to Columns() function to specify an empty delimiter

What inspired this wish list request?  A Community Discussion item came in that had the need to separate into columns, each individual character in found in one of the columns in a data table. 

 

 

What is the improvement you would like to see? 

I would like to enhance the Text to Columns function to be able to specify an empty delimiter, which would indicate to the function to use each individual character as a new column

 

Why is this idea important? 

It adds nice functionality to the function and it also makes the function more consistent with other JLS functions, such as the Words function.

 

1 Comment
Mauro_Gerber
Level V

In addition I would like to extend this to the "word" and "words" functions:

Names Default To Here( 1 );
temp = "1;2;;4";
word(3,temp,";");

this should return a "" and not a 4

Names Default To Here( 1 );
temp = "1;2;;4";
words(temp,";");

and this should be {"1", "2", "", "4"}
Keeping the current behaviour is ok, but add an option like : 

words(temp,";",Separate at each delimiter(1));