747102_en-US

liliconcom

New column from existing one with dashes and periods

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

Automation and ScriptingRe: New column from existing one with dashes and periods

You can for example use If + Contains in a Formula

If(Contains(:document, "399"),
	"399"
,
	"Standard"
);