Subscribe Bookmark RSS Feed

Separate number and character in cell

tajrida

Community Trekker

Joined:

Apr 8, 2015

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

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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

1 REPLY
Solution

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