679519_en-US

liliconcom

Modifying Column names

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.

Content OrganizationData Blending and CleanupData Exploration and VisualizationRe: Modifying Column names

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

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

Re: Modifying Column names

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="">"))</SET>