cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

Extracting numbers from a set of numbers in a column

Let say you have the following data table with 6 digits numbers in one column (Number 1) and you are interested in extracting only 4 numbers from those 6 numbers into a new column (Derived Numbers). How do you go about doing that? Thanks in advance.

Number 1Derived Numbers
201409
201589
201378
201411
201091
Jenkins Macedo
2 REPLIES 2

Re: Extracting numbers from a set of numbers in a column

Thanks, I figured it out Here is screenshot. I used the Left from the Character function group and selected the number of numbers that I want to extract from the original table.

9333_NumberExtract-Left.jpg

Jenkins Macedo

Re: Extracting numbers from a set of numbers in a column

The screenshot is actually a screenshot from one of data tables, which I was working with yesterday. For this specific example your formula would rather be:

          Left(Number 1, 4)

Jenkins Macedo