cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
tajrida
Level III

Separate number and character in cell

Hello,

I have a column in given format, Is it possible to remove the “hr.” from the cells and just leave the  numbers?

1.2 hrs

1.6 hrs

4.5 hrs

7.6 hrs

8.2 hrs

1.0 hrs

0.9 hrs

The output I desire is:

1.2

1.6

4.5

7.6

8.2

1.0

0.9

Mohammed Ahmed
1 ACCEPTED SOLUTION

Accepted Solutions
stan_koprowski
Community Manager Community Manager

Re: Separate number and character in cell

Hi,

There are several ways to do this depending on the version of JMP you are using and how you would like to approach it.

One way would be to create new column and add a formula as follows:

9224_Screen Shot 2015-07-14 at 8.53.34 PM.png

Or if you are using JMP version 12 you could use Text to Columns utilities as follows:

1. Select the column you would like to convert and the select the option under the utilities menu.

9221_text to column.png

2. Put your delimiter in as a space (" "):

9222_delimiter.png

3. This will give you the following output:

9223_Screen Shot 2015-07-14 at 9.01.00 PM.png

Others might have more creative approaches.

Best,

Stan

View solution in original post

1 REPLY 1
stan_koprowski
Community Manager Community Manager

Re: Separate number and character in cell

Hi,

There are several ways to do this depending on the version of JMP you are using and how you would like to approach it.

One way would be to create new column and add a formula as follows:

9224_Screen Shot 2015-07-14 at 8.53.34 PM.png

Or if you are using JMP version 12 you could use Text to Columns utilities as follows:

1. Select the column you would like to convert and the select the option under the utilities menu.

9221_text to column.png

2. Put your delimiter in as a space (" "):

9222_delimiter.png

3. This will give you the following output:

9223_Screen Shot 2015-07-14 at 9.01.00 PM.png

Others might have more creative approaches.

Best,

Stan