[SOLVED] getting error while using GETTOK function

 
-SET &GROUPING='Grouping_1|Grouping_2';
-SET &SORTING='Sorting_1~LOWEST|Sorting_2~HIGHEST';
-SET &SUMMING='Summing_1|Summing_2';
-SET &GROUPPBY_1=GETTOK(&GROUPING, 40, 1, '|',20,'GROUPBY_1');
-SET &GROUPPBY_2=GETTOK(&GROUPING, 40, 2, '|',20,'GROUPBY_2');
-SET &SORTBY_1=GETTOK(&SORTING, 50, 1, '|',20,'SORTBY_1');
-SET &SORTBY_11=GETTOK(&SORTBY_1, 50, 1, '~',20,'SORTBY_11');
-SET &SORTBY_12=GETTOK(&SORTBY_1, 50, -1, '~',20,'SORTBY_12');
-SET &SUMBY = CTRAN(100,&SUMMING,124,32,SUMBY);

-TYPE SUMBY : &SUMBY
-TYPE GROUPPBY_1 :&GROUPPBY_1
-TYPE GROUPPBY_2 :&GROUPPBY_2
-TYPE SORTBY_1 :&SORTBY_1
-TYPE SORTBY_11 :&SORTBY_11
-TYPE SORTBY_12 :&SORTBY_12

The &GROUPING,&SORTING and &SUMMING are passed in the URL. The length of the variables varies depending upon the user input.

When I execute this code im getting some junk values, and some values are getting truncated as shown below.

SUMBY : Summing_1 Summing
GROUPPBY_1 :Grouping_1
GROUPPBY_2 :Grouping_2 ˜m
SORTBY_1 :Sorting_1~LOWEST
SORTBY_11 :Sorting_1
SORTBY_12 :LOWEST šm

I am not able to understand why this occurs. Please help to resolve this issue.
Thanks.

This message has been edited. Last edited by: Kerry,

WebFOCUS 7.1.4,Linux,
HTML,PDF,Excel,CSV

Posts: 25 | Location: Chennai | Registered: August 27, 2008

<JG>

posted

When using functions in -SET statements the target cannot be a column name.
It MUST be a format for example

-SET &GROUPPBY_1=GETTOK(&GROUPING, 40, 1, '|',20,'A20');

NOT

-SET &GROUPPBY_1=GETTOK(&GROUPING, 40, 1, '|',20,'GROUPBY_1');

This applies to all functions. Also note it must have the quotes around the format,
look at your CTRAN that should be 'A32' NOT SUMBY

Tony A

Expert

posted

Hide Post

Also bear in mind that the second parameter in GETTOK is the incoming length and you are specifying a fixed length of 40 but state that they are variable in length.

So instead of -

-SET &GROUPPBY_1=GETTOK(&GROUPING, 40, 1, '|',20,'A20');

use -

-SET &GROUPPBY_1=GETTOK(&GROUPING, &GROUPING.LENGTH, 1, '|',20,'A20');

I would also stay clear of using a pipe "|" character for demlimitation of values as who knows how WF might treat it in future! I would stick with semi colons ";" instead.

T