cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles