Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Extracting numbers from a set of numbers in a column

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Extracting numbers from a set of numbers in a column

Jul 29, 2015 7:36 AM
(1259 views)

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 1 | Derived Numbers |
---|---|

201409 | |

201589 | |

201378 | |

201411 | |

201091 |

Jenkins Macedo

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Jul 29, 2015 8:17 AM
(1161 views)
| Posted in reply to message from jenkins_macedo 07/29/2015 10:36 AM

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.

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Jul 30, 2015 6:57 AM
(1161 views)
| Posted in reply to message from jenkins_macedo 07/29/2015 11:17 AM

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