Subscribe Bookmark RSS Feed

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

bhagbom

Community Trekker

Joined:

Jun 23, 2011

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.
1 ACCEPTED SOLUTION

Accepted Solutions
pmroz

Super User

Joined:

Jun 23, 2011

Solution
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.
2 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

Solution
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.
bhagbom

Community Trekker

Joined:

Jun 23, 2011

Thanks PMroz! It appears that solved the issue!