cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

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