How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

mengzy1974 — Fri, 09 Jun 2023 22:08:14 GMT

I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.

Re: How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

jthi — Fri, 12 Mar 2021 08:56:49 GMT

Something like this might do it:

Names Default To Here(1);

dt = New Table("Untitled 390",
	Add Rows(9),
	Compress File When Saved(1),
	New Column("a",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([., ., ., ., ., ., ., ., .])
	),
	New Column("a+LCL",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([1, ., ., ., ., ., ., ., .])
	),
	New Column("b+LCL",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([., ., ., ., ., ., ., ., .])
	)
);

wait(1);

colNames = dt << Get Column Names("String");
colContainsList = {"UL", "LL", "UCL", "LCL", "USL", "LSL"};

For(i = 1, i <= N Items(colNames), i++,
	For(k = 1, k <= N Items(colContainsList), k++,
		If(Contains(colNames[i], colContainsList[k]),
			Summarize(dt, uniqValues = By(colNames[i]));
			If(N Items(uniqValues) == 1 & uniqValues[1] == ".",
				dt << Delete Columns(colNames[i]);
			);
			break();
		);
	);
);

Are you sure you want to check if column name contains any of those strings or if the column name ends in them?

topic How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty) in Discussions

How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

Re: How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)