2690_en-US

liliconcom

Using JSL to add column where value for all rows is fixed character stringI 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 stringThanks PMroz! It appears that solved the issue!Re: Using JSL to add column where value for all rows is fixed character stringTry 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.