Help Locating a Column Header Editing Utility Tools?

Thierry_S

Hi JMP Community,

 

I have been looking without success for an utility add-in that would simplify and expedite the management of column names in JMP 13.1.

 

Ideally, this utility add-in would perform the following:

1. Add a prefix and/or suffix to selected existing column names
2. Rename a set of selected target columns based on the names of selected sources columns; adding a prefix and/or a suffix
   1. Example: input
      1. Source columns = Protein 1, Protein 2, Protein 3
      2. Target columns = Column 4, Column 5, Column 6
      3. Prefix = "Log10 "
   2. Output:
      1. Target columns = Log10 Protein 1, Log10 Protein 2, Log10 Protein 3

My JSL skills being pretty limited, I would greatly appreciate receiving your feedback about potential existing add-in or about JSL code that would achieve these 2 functions.

 

Thank you,

 

TS

uday_guntupalli

@Thierry_S , 
      I don't know of add-ins, but maybe try something like this : 

 

cleaner = function({collist,flag,tag},{default local},
		    newcollist = {}; 
		    If(flag == "prefix",
		       for(i = 1, i <= N items(collist), i++,
			   Insert Into(newcollist,tag || collist[i]);
			  );
			,
			// else 
			If(flag == "postfix",
			   for(i = 1, i <= N items(collist), i++,
				Insert Into(newcollist, collist[i] || tag);
			      );
			  );     
		      ); 
    		      return(newcollist); 
		   ); 

/* Demo */ 
collist = {"Protein 1","Protein 2","Protein 3"};
tag = "Log10"; 
flag = "prefix"; 

// Prefix 
PrefixExample = cleaner(collist,flag,tag); 
Show(PrefixExample);

// Postfix
flag = "postfix";
PostfixExample = cleaner(collist,flag,tag); 
Show(PostfixExample);

 In order to retrieve the column names as a list from a data table, you can do the following: 

 

ColNamesAsList = dt << Get Column Names("String"); // Assuming dt is a reference to the data table