Munger or Substr?

house91

Hi all,

Working with a dataset where I have four descriptors that I want to utilize in my column headings.

I have not input my numbers yet, but I would like to know if I wanted to change my column headings, in the first four, to a combination of descriptors under "Description" and "Description 2"  for their associated abbreviations what formula I would use besides manually doing it? I'm looking at Substr, but Munger seems to be the one to utilize.

Thank you,

Brandon

JohnPonte

I think either method would work for you. But in your case, where you know exactly what the strings are and what you want to change them to, I would use Munger, since it is a simple find and replace. I use Substr when I'm trying to find a specific string within a general string, and I don't know what the general string is or if my substring will even exist within it.

If I understand your problem correctly (and I'm not convinced I do) here is the JSL for making the changes as you described:

col = column("Att1_Stat1");

colName = col << getName();

colName = munger(colName, 1, "Att1", :Description[1]);

colName = munger(colName, 1, "Stat1", :Description2[1]);

col << SetName(colName);

col = column("Att1_Stat2");

colName = col << getName();

colName = munger(colName, 1, "Att1", :Description[1]);

colName = munger(colName, 1, "Stat2", :Description2[2]);

col << SetName(colName);

col = column("Att2_Stat1");

colName = col << getName();

colName = munger(colName, 1, "Att2", :Description[2]);

colName = munger(colName, 1, "Stat1", :Description2[1]);

col << SetName(colName);

col = column("Att2_Stat2");

colName = col << getName();

colName = munger(colName, 1, "Att2", :Description[2]);

colName = munger(colName, 1, "Stat2", :Description2[2]);

col << SetName(colName);

Hope this helps!