topic Re: Modifying Column names in Discussions

Modifying Column names

AshrafFathy — Tue, 19 Sep 2023 20:05:37 GMT

Hi, I have the column header very long after I extract from STDF data file.

Here is the format I have

TestName..... <> Test Name2....

How can I make the column header only have the Test Name2.... and remove every thing else without having to export and import from Excel.

Thanks.

Re: Modifying Column names

txnelson — Tue, 19 Sep 2023 20:19:15 GMT

Is there a standard delimiter that separates TestName from Test Name2? If not a delimiter, is there a standard structure for TestName?

Re: Modifying Column names

AshrafFathy — Tue, 19 Sep 2023 20:33:07 GMT

The only standard delimiter is <> . Also, the number of characters in the test name and test name 2 are different.

Re: Modifying Column names

txnelson — Tue, 19 Sep 2023 21:44:24 GMT

Here is an example of how to change the name to the second name in the test name

names default to here(1);
dt=New Table( "Example",
	Add Rows( 0 ),
	New Column( "thisisatestname00001abc<>andthesecondname<>andmoreinfo",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Set Selected,
		Set Values( [] )
	)
);

wait(5);

column(1)<<set name(word(2,column(1)<<get name,"<>"))

Re: Modifying Column names

AshrafFathy — Mon, 25 Sep 2023 22:12:11 GMT

Thanks but that did not work for some reason.

I opted out to export and import back from Excel after fixing the tables headers.

It is just hard to understand why JMP have no such simple capability compared to excel which does it in a couple of clicks.

Ashraf

Re: Modifying Column names

txnelson — Tue, 26 Sep 2023 01:04:11 GMT

Provide me with a real example and I will see what the issue is.

Re: Modifying Column names

jthi — Tue, 26 Sep 2023 05:38:37 GMT

JMP does offer you with Recode Column Names

and Extract Segment could be something which works here

Re: Modifying Column names

AshrafFathy — Tue, 26 Sep 2023 18:08:48 GMT

Thanks. I tried the Recode already several time and the extract segment and that did not work either.

It seems because the number of characters before and after the <> symbol varies from one test name to another, I end up with some test names segmented and other not fro some reason.

Ashraf

Re: Modifying Column names

txnelson — Tue, 26 Sep 2023 18:52:53 GMT

Here is another attempt in finding a solution for you. The script first creates a sample data table, then it adds a new column that takes the second element from the original test name.

names default to here(1);
dt=new table("example",
	new column( "TestName", Character),
	add rows( 100 )
);

// Create sample data
characterPool = "kj;adoilkz;vclkeiop8uyhvjnbuiaedriuna;lkdalkiouie;lkakjfloauifadkjfbvsa;ihdiekd";
for each row(
	:Test Name = "";
	For( i=1, i<=floor(random uniform(2,4)), i++,
		:TestName = :testName || substr(characterPool,floor(random uniform(1,length(characterPool)-1))) ||"<>";
		if(i>2,show(row()))
));


// Create a new column with only the 2nd element of the Test Names
dt << new column("Short Test Name", character,
	formula(word(2,:Test Name,"<>") )
)