topic Re: Munger or Substr? in Discussions

Munger or Substr?

house91 — Tue, 18 Oct 2016 23:10:20 GMT

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

Re: Munger or Substr?

JohnPonte — Thu, 30 Apr 2015 18:01:27 GMT

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!

Re: Munger or Substr?

Craige_Hales — Wed, 09 Nov 2016 10:02:28 GMT

Good use of munger. Some ideas: JSL Character String Functions .

Re: Munger or Substr?

house91 — Thu, 30 Apr 2015 23:25:51 GMT

John this is exactly what I was looking for, thank you.

I've never used the Munger function before, but I wanted to have a formula change the column headings and not just manually input them.

Thank you again.

Re: Munger or Substr?

house91 — Fri, 01 May 2015 00:28:41 GMT

So I've run into a new problem.

When the tables are turned into a script and placed in a journal the subsequent table produced from the hyperlink has no data input and the following errors appear:

"could not find column 1 times At rows: {1} Operation: Column, Column/*###*/("Att1_Stat1")"

This error goes from 1-10 in the rows and for each treatment column.

Re: Munger or Substr?

JohnPonte — Fri, 01 May 2015 12:49:42 GMT

The script will only work once! After that, your column headings have been changed. You could wrap each block of code in an if() so it will only attempt to change the column heading if it finds the column with the original name. Or you could remove the script once you've run it or before you save it to a journal.