744871_en-US

liliconcom

JSL question - returning a character string into a new column based on values within another column

I almost have this; but can't seem to get it generated in a JSL script. The formula editor is doing almost exactly what I want... but when attempting to do it in a script... I can't seem to get it to work. 

 

Desired result is in column 2; I apply the formula shown in the column editor to get the desired result.  

//This is what I input into formula editor and it works fine;
item_lst = Words( Substitute( :Input, "/", "/;" ), ";" );
result_str = "";
For( i = 1, i <= N Items( item_lst ), i++,
	If( item_lst[i] == "/",
		result_str = result_str || "N",
		result_str = result_str || "Y"
	)
);
result_str;

When I try&nbsp;to&nbsp;create&nbsp;a&nbsp;new&nbsp;column&nbsp;within&nbsp;a&nbsp;JSL script&nbsp;and&nbsp;the&nbsp;I get&nbsp;the&nbsp;result&nbsp;in&nbsp;column&nbsp;3.&nbsp;I seem&nbsp;to&nbsp;be&nbsp;nesting&nbsp;incorrectly&nbsp;and&nbsp;I can't&nbsp;seem&nbsp;to&nbsp;find&nbsp;this...&nbsp;

Here&nbsp;is&nbsp;the&nbsp;jsl&nbsp;code.&nbsp;Any&nbsp;help would be much appreciated.

da = Current Data Table();

da <<NEW column=""></NEW>

 

Automation and ScriptingRe: JSL question - returning a character string into a new column based on values within another column

Hi Jim... I could swear I did that before... the number of times I checked my semicolons, commas and parentheses... 

 

that said... I thank you... it works perfectly now... 

 

not sure how I spent so much time on this. Too late. 

Re: JSL question - returning a character string into a new column based on values within another column

Your issue was that you had ")" in a couple of incorrect places.  Here is your code with my modifications

da = Current Data Table();

da << New Column( "Keystring", Character );
:Keystring << Set Formula(
	item_lst = Words( Substitute( :Input, "/", "/;" ), ";" );

	result_str = "";
	For( i = 1, i <= N Items( item_lst ), i++,
		If( item_lst[i] == "/",
			result_str = result_str || "N",
			result_str = result_str || "Y"
		)
	);
	result_str;
);