New column from existing one with dashes and periods

MultipleLion305 — Mon, 15 Apr 2024 12:45:44 GMT

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

Re: New column from existing one with dashes and periods

jthi — Mon, 15 Apr 2024 12:55:22 GMT

You can for example use If + Contains in a Formula

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

topic Re: New column from existing one with dashes and periods in Discussions

New column from existing one with dashes and periods

Re: New column from existing one with dashes and periods