topic Re: Using JSL to add column where value for all rows is fixed character string in Discussions

Using JSL to add column where value for all rows is fixed character string

bhagbom — Tue, 07 Dec 2010 15:10:42 GMT

I have a script that opens a .txt file and is adding a column that categorizes that set of data with by asking user to enter a string to categorize it. The file will be later joined with other files. I cannot seem to pass the string into all rows for the new column.

Once file is open:

New Window ("New Window",
< categorytextbox = Text Edit Box ( "Enter category here" ),
Button Box ( "OK" ),
);

::category = category << get text;

new column(
"Category",
Character,
Nominal,
Formula (::category),
);

Any help is appreciated. I've tried using Set Values function instead of formula with no success.

Re: Using JSL to add column where value for all rows is fixed character string

pmroz — Tue, 07 Dec 2010 15:25:45 GMT

Try using different variable names for the value of category and the column. I've run into trouble in the past when my variable had the same name as one of my columns.

Re: Using JSL to add column where value for all rows is fixed character string

bhagbom — Tue, 07 Dec 2010 16:32:30 GMT

Thanks PMroz! It appears that solved the issue!