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

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