Hi, I am new to programming in general and am having trouble with this one column in JMP. I want to create a new column from one that is autogenerated, but my if/ then statements aren't working. I think its because sometimes there are words and spaces within the strings of numbers and often dashes and periods. I am looking for only one number within a string of numbers. Sometimes it will be at the front, sometimes sandwiched in the middle. I want to find the strings with the number 399 in there somewhere, all others will be standard. Can someone help? Example:
| document | requisition |
| 100-399-214.2 | 399 |
| 399-214.2-199 | 399 |
| 100-100-344 | standard |
| 214.2-100 and 598-100-399 | 399 |