cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar
0 Kudos

Text to Columns

Status: Acknowledged Submitted by on ‎06-19-2024 03:19 PM
2 Comments (2 New)

What inspired this wish list request? 

Currently, Text to Columns supports only one delimiter. Often, multiple delimiters may simultaneously exist in the data. In such cases, the operation has to be done sequentially.

 

What is the improvement you would like to see? 

Enable use of multiple delimiters (e.g., space, -, _, /) simultaneously. Also provide users the option to retain or remove the source column.

 

Why is this idea important? 

Ease of use, increased efficiency.

 

2 Comments
mia_stephens
Staff
Staff
yesterday
yesterday
Status changed to: Acknowledged
 
hogi
Level XI
yesterday
yesterday

hi,

 

current Text to Columns accepts multiple delimiters : )
very useful! 

what could be optimized in one of the future releases:

  1. add an option how to handle blocks of multiple delimiters:
      Text To Columns: handle missing data correctly 
  2. an option to save column formulas Word (...) instead of just creating the columns. 
    with the current approach one cannot update the data table with new data.
  3.  saving list of cols created by text to column