nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Modifying Column names

AshrafFathy

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.

Accepted answers

All comments

txnelson

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

AshrafFathy

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

txnelson

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,"<>"))

AshrafFathy

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