How to create a formula column that extract letters/numbers from an ID?I have a list of ID numbers. However, I only number which is important to me is the last five digits from the ID number. I'm sure there's a formula column script we could utilize to perform this.
For example:
The id number that i have is 24KL-L200123. I just need to create a formula column that could pull the last 5 digits and the end result would be 00123.
Thanks. sincerely appreciate any advise on this
AnalyticsData TableDOEGraphicsOtherScriptingRe: How to create a formula column that extract letters/numbers from an ID?Are the ID numbers always similar format to your example? As in are the last five characters in the string always digits you want? If they are you could use Right() function.
Right("24KL-L200123",5);
Re: How to create a formula column that extract letters/numbers from an ID?it worked. I'm interested to know what's the fundamental behind this. Could you share them a little in detail. Thank you
Re: How to create a formula column that extract letters/numbers from an ID?I suggest checking out JMP Scripting Index (from JMP go to Help / Scripting Index) and https://www.jmp.com/support/help/en/15.2/index.shtml#page/jmp/character-functions.shtml .
Right(string, count:(returns a substring of the right-most count characters of the string.
Substr(string, startIndex, count:(extracts the characters that are the portion of the first argument string. Begins at the position given by the second argument (startIndex), and ends based on the number of characters specified in the third argument (count). If start is negative, Substr searches backward from start from the end of the string. If length is negative or absent, Substr returns a string that begins with start and continues to the end of the text string.
