BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
tajrida
Community Trekker

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

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

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