cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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));