Hi,

Below is part of my FEX code.

-SET &ACCESS=&REVOKE.().REVOKE.;
-SET &VERBOBJ = STRREP(&ACCESS.LENGTH, &ACCESS, 4,' OR ', 1, ',', &ACCESS.LENGTH, A4109);
-TYPE &VERBOBJ

&REVOKE will get almost 500 user id from a list box under HTML page. It is from multiselect list box OR will be appended to each user id. i use strrep to replace all OR with , (comma).

While printing the value from &VEROBJ nothing is displayed.

If less than 450 user id is selected from HTML , it display all those selected user id.

Below is result from HTML,

-SET &ACCESS='002' OR '003' OR '00G' OR '01K' OR '020' OR '03B' OR '03D' OR '047' OR '04A' OR '04N' OR '04T' OR '04U' OR '04V' OR '065' OR '06A' OR '06Q' OR '07E' OR '07F' OR '07Z' OR '08X' OR '0A7' OR '0AE' OR '0BD' OR '0BE' OR '0BR' OR '0CR' OR '0CZ' OR '0D0' OR '0D2' OR '0DQ' OR '0DS' OR '0DT' OR '0E1' OR '0E4' OR '0EB' OR '0EN' OR '0EP' OR '0FM' OR '0G7' OR '0G9' OR '0GA' OR '0GF' OR '0GV' OR '0HA' OR '0HH' OR '0HR' OR '0HY' OR '0J2' OR '0J8' OR '0JB' OR '0JQ' OR '0JS' OR '0JT' OR '0JW' OR '0JX' OR '0K4' OR '0KW' OR '0M5' OR '0M6' OR '0MH' OR '0NC' OR '0NR' OR '0NV' OR '0P4' OR '0PS' OR '0PT' OR '0Q1' OR '0Q2' OR '0Q3' OR '0Q4' OR '0Q5' OR '0Q6' OR '0Q7' OR '0Q8' OR '0QM' OR '0RA' OR '0S8' OR '0W9' OR '0WT' OR '0WU' OR '0WX' OR '0WZ' OR '0X1' OR '0X4' OR '0X5' OR '0X9' OR '0XA' OR '0XJ' OR '0XK' OR '0XM' OR '0XN' OR '0XP' OR '0XQ' OR '0XV' OR '0XW' OR '0XX' OR '0Y3' OR '0Y7' OR '0Y8' OR '0YA' OR '0YE' OR '0ZC' OR '0ZJ' OR '0ZM' OR '10M' OR '10T' OR '10Y' OR '11D' OR '12M' OR '12T' OR '12V' OR '15N' OR '18D' OR '18X' OR '19A' OR '19S' OR '1FM' OR '1G9' OR '1GD' OR '1GF' OR '1GY' OR '1H6' OR '1JS' OR '1K8' OR '1KR' OR '1KZ' OR '1M8' OR '1MX' OR '1NT' OR '1NW' OR '1NX' OR '1P6' OR '1P7' OR '1P9' OR '1PC' OR '1PJ' OR '1PX' OR '1Q3' OR '1Q6' OR '1QC' OR '1QX' OR '1RU' OR '1RW' OR '1TW' OR '1UU' OR '1UW' OR '1V0' OR '1V5' OR '1VG' OR '1VH' OR '1VN' OR '1VP' OR '1VT' OR '1VX' OR '1WN' OR '1X1' OR '1X4' OR '1XU' OR '1ZC' OR '1ZD' OR '1ZQ' OR '1ZU' OR '20D' OR '20E' OR '20Q' OR '20W' OR '21A' OR '21N' OR '232' OR '23F' OR '23X' OR '24G' OR '24U' OR '26B' OR '26E' OR '26M' OR '26U' OR '26V' OR '26W' OR '27T' OR '2A6' OR '2A9' OR '2AJ' OR '2AT' OR '2BC' OR '2C0' OR '2C1' OR '2CF' OR '2D8' OR '2DR' OR '2DT' OR '2DU' OR '2DV' OR '2E8' OR '2EC' OR '2EM' OR '2FG' OR '2FH' OR '2H9' OR '2HQ' OR '2HW' OR '2JC' OR '2JF' OR '2JG' OR '2K9' OR '2KF' OR '2KK' OR '2KM' OR '2KP' OR '2M7' OR '2ME' OR '2MN' OR '2MZ' OR '2NX' OR '2NY' OR '2P0' OR '2PF' OR '2PH' OR '2PJ' OR '2PK' OR '2QY' OR '2R2' OR '2R8' OR '2R9' OR '2RA' OR '2RB' OR '2RC' OR '2RV' OR '2TB' OR '2TV' OR '2U8' OR '2UA' OR '2UB' OR '2UP' OR '2VF' OR '2VM' OR '2WB' OR '2XB' OR '2Y2' OR '2Y3' OR '300' OR '309' OR '30N' OR '30U' OR '314' OR '317' OR '31P' OR '321' OR '322' OR '323' OR '324' OR '325' OR '32J' OR '32K' OR '32M' OR '32N' OR '32P' OR '32R' OR '32T' OR '32U' OR '32V' OR '337' OR '34D' OR '34H' OR '35E' OR '35F' OR '35R' OR '36B' OR '36C' OR '36E' OR '36F' OR '37R' OR '385' OR '3CC' OR '3CG' OR '3CW' OR '3EC' OR '3FH' OR '3GF' OR '3GG' OR '3GH' OR '3GJ' OR '3H9' OR '3HW' OR '3HX' OR '3JT' OR '3K8' OR '3K9' OR '3M0' OR '3N9' OR '3PC' OR '3PD' OR '3PG' OR '3PZ' OR '3Q6' OR '3QW' OR '3RK' OR '3RY' OR '3TV' OR '3U8' OR '3V9' OR '3VY' OR '3VZ' OR '3W4' OR '3W5' OR '3WE' OR '3X1' OR '3X9' OR '3Y5' OR '3Y7' OR '3YZ' OR '3ZG' OR '41Z' OR '43A' OR '44N' OR '45Z' OR '47P' OR '49Y' OR '4AA' OR '4DM' OR '4EE' OR '4EY' OR '4F2' OR '4JB' OR '4KD' OR '4KW' OR '4KX' OR '4N2' OR '4NZ' OR '4PT' OR '4RE' OR '4T5' OR '4UW' OR '4V5' OR '4V6' OR '4VP' OR '4YE' OR '4YX' OR '4YZ' OR '501' OR '503' OR '506' OR '50D' OR '50E' OR '50F' OR '50H' OR '50M' OR '50N' OR '50Q' OR '50U' OR '50X' OR '510' OR '511' OR '513' OR '514' OR '515' OR '517' OR '518' OR '519' OR '51A' OR '51E' OR '51F' OR '51P' OR '51R' OR '51V' OR '51Z' OR '521' OR '522' OR '523' OR '527' OR '528' OR '52K' OR '53B' OR '53V' OR '53W' OR '53X' OR '53Y' OR '54B' OR '559' OR '55R' OR '55Y' OR '57F' OR '57P' OR '58M' OR '58R' OR '58U' OR '5AH' OR '5B6' OR '5B9' OR '5BD' OR '5BR' OR '5CM' OR '5CR' OR '5CW' OR '5D0' OR '5D1' OR '5DF' OR '5DG' OR '5DK' OR '5DL' OR '5DZ' OR '5EZ' OR '5F0' OR '5F1' OR '5F4' OR '5F7' OR '5F8' OR '5F9' OR '5FB' OR '5FG' OR '5FJ' OR '5FU' OR '5FV' OR '5G0' OR '5G2' OR '5G4' OR '5G5' OR '5G6' OR '5G8' OR '5GB' OR '5GP' OR '5GU' OR '5GZ' OR '5H0' OR '5H8' OR '5H9' OR '5HD' OR '5HH' OR '5HN' OR '5HZ' OR '5J1' OR '5J2' OR '5J7' OR '5J9' OR '5JF' OR '5JL' OR '5JY' OR '5KC' OR '5LW' OR '5MT' OR '5NJ' OR '5NN' OR '5NV' OR '5PV' OR '5PW' OR '5PZ' OR '5Q3' OR '5Q6' OR '5QJ' OR '5QX' OR '5QZ' OR '5R5' OR '5R8' OR '5RD' OR '5RG' OR '5S1' OR '5SB';
-SET &VERBOBJ = STRREP(4109, '002' OR '003' OR '00G' OR '01K' OR '020' OR '03B' OR '03D' OR '047' OR '04A' OR '04N' OR '04T' OR '04U' OR '04V' OR '065' OR '06A' OR '06Q' OR '07E' OR '07F' OR '07Z' OR '08X' OR '0A7' OR '0AE' OR '0BD' OR '0BE' OR '0BR' OR '0CR' OR '0CZ' OR '0D0' OR '0D2' OR '0DQ' OR '0DS' OR '0DT' OR '0E1' OR '0E4' OR '0EB' OR '0EN' OR '0EP' OR '0FM' OR '0G7' OR '0G9' OR '0GA' OR '0GF' OR '0GV' OR '0HA' OR '0HH' OR '0HR' OR '0HY' OR '0J2' OR '0J8' OR '0JB' OR '0JQ' OR '0JS' OR '0JT' OR '0JW' OR '0JX' OR '0K4' OR '0KW' OR '0M5' OR '0M6' OR '0MH' OR '0NC' OR '0NR' OR '0NV' OR '0P4' OR '0PS' OR '0PT' OR '0Q1' OR '0Q2' OR '0Q3' OR '0Q4' OR '0Q5' OR '0Q6' OR '0Q7' OR '0Q8' OR '0QM' OR '0RA' OR '0S8' OR '0W9' OR '0WT' OR '0WU' OR '0WX' OR '0WZ' OR '0X1' OR '0X4' OR '0X5' OR '0X9' OR '0XA' OR '0XJ' OR '0XK' OR '0XM' OR '0XN' OR '0XP' OR '0XQ' OR '0XV' OR '0XW' OR '0XX' OR '0Y3' OR '0Y7' OR '0Y8' OR '0YA' OR '0YE' OR '0ZC' OR '0ZJ' OR '0ZM' OR '10M' OR '10T' OR '10Y' OR '11D' OR '12M' OR '12T' OR '12V' OR '15N' OR '18D' OR '18X' OR '19A' OR '19S' OR '1FM' OR '1G9' OR '1GD' OR '1GF' OR '1GY' OR '1H6' OR '1JS' OR '1K8' OR '1KR' OR '1KZ' OR '1M8' OR '1MX' OR '1NT' OR '1NW' OR '1NX' OR '1P6' OR '1P7' OR '1P9' OR '1PC' OR '1PJ' OR '1PX' OR '1Q3' OR '1Q6' OR '1QC' OR '1QX' OR '1RU' OR '1RW' OR '1TW' OR '1UU' OR '1UW' OR '1V0' OR '1V5' OR '1VG' OR '1VH' OR '1VN' OR '1VP' OR '1VT' OR '1VX' OR '1WN' OR '1X1' OR '1X4' OR '1XU' OR '1ZC' OR '1ZD' OR '1ZQ' OR '1ZU' OR '20D' OR '20E' OR '20Q' OR '20W' OR '21A' OR '21N' OR '232' OR '23F' OR '23X' OR '24G' OR '24U' OR '26B' OR '26E' OR '26M' OR '26U' OR '26V' OR '26W' OR '27T' OR '2A6' OR '2A9' OR '2AJ' OR '2AT' OR '2BC' OR '2C0' OR '2C1' OR '2CF' OR '2D8' OR '2DR' OR '2DT' OR '2DU' OR '2DV' OR '2E8' OR '2EC' OR '2EM' OR '2FG' OR '2FH' OR '2H9' OR '2HQ' OR '2HW' OR '2JC' OR '2JF' OR '2JG' OR '2K9' OR '2KF' OR '2KK' OR '2KM' OR '2KP' OR '2M7' OR '2ME' OR '2MN' OR '2MZ' OR '2NX' OR '2NY' OR '2P0' OR '2PF' OR '2PH' OR '2PJ' OR '2PK' OR '2QY' OR '2R2' OR '2R8' OR '2R9' OR '2RA' OR '2RB' OR '2RC' OR '2RV' OR '2TB' OR '2TV' OR '2U8' OR '2UA' OR '2UB' OR '2UP' OR '2VF' OR '2VM' OR '2WB' OR '2XB' OR '2Y2' OR '2Y3' OR '300' OR '309' OR '30N' OR '30U' OR '314' OR '317' OR '31P' OR '321' OR '322' OR '323' OR '324' OR '325' OR '32J' OR '32K' OR '32M' OR '32N' OR '32P' OR '32R' OR '32T' OR '32U' OR '32V' OR '337' OR '34D' OR '34H' OR '35E' OR '35F' OR '35R' OR '36B' OR '36C' OR '36E' OR '36F' OR '37R' OR '385' OR '3CC' OR '3CG' OR '3CW' OR '3EC' OR '3FH' OR '3GF' OR '3GG' OR '3GH' OR '3GJ' OR '3H9' OR '3HW' OR '3HX' OR '3JT' OR '3K8' OR '3K9' OR '3M0' OR '3N9' OR '3PC' OR '3PD' OR '3PG' OR '3PZ' OR '3Q6' OR '3QW' OR '3RK' OR '3RY' OR '3TV' OR '3U8' OR '3V9' OR '3VY' OR '3VZ' OR '3W4' OR '3W5' OR '3WE' OR '3X1' OR '3X9' OR '3Y5' OR '3Y7' OR '3YZ' OR '3ZG' OR '41Z' OR '43A' OR '44N' OR '45Z' OR '47P' OR '49Y' OR '4AA' OR '4DM' OR '4EE' OR '4EY' OR '4F2' OR '4JB' OR '4KD' OR '4KW' OR '4KX' OR '4N2' OR '4NZ' OR '4PT' OR '4RE' OR '4T5' OR '4UW' OR '4V5' OR '4V6' OR '4VP' OR '4YE' OR '4YX' OR '4YZ' OR '501' OR '503' OR '506' OR '50D' OR '50E' OR '50F' OR '50H' OR '50M' OR '50N' OR '50Q' OR '50U' OR '50X' OR '510' OR '511' OR '513' OR '514' OR '515' OR '517' OR '518' OR '519' OR '51A' OR '51E' OR '51F' OR '51P' OR '51R' OR '51V' OR '51Z' OR '521' OR '522' OR '523' OR '527' OR '528' OR '52K' OR '53B' OR '53V' OR '53W' OR '53X' OR '53Y' OR '54B' OR '559' OR '55R' OR '55Y' OR '57F' OR '57P' OR '58M' OR '58R' OR '58U' OR '5AH' OR '5B6' OR '5B9' OR '5BD' OR '5BR' OR '5CM' OR '5CR' OR '5CW' OR '5D0' OR '5D1' OR '5DF' OR '5DG' OR '5DK' OR '5DL' OR '5DZ' OR '5EZ' OR '5F0' OR '5F1' OR '5F4' OR '5F7' OR '5F8' OR '5F9' OR '5FB' OR '5FG' OR '5FJ' OR '5FU' OR '5FV' OR '5G0' OR '5G2' OR '5G4' OR '5G5' OR '5G6' OR '5G8' OR '5GB' OR '5GP' OR '5GU' OR '5GZ' OR '5H0' OR '5H8' OR '5H9' OR '5HD' OR '5HH' OR '5HN' OR '5HZ' OR '5J1' OR '5J2' OR '5J7' OR '5J9' OR '5JF' OR '5JL' OR '5JY' OR '5KC' OR '5LW' OR '5MT' OR '5NJ' OR '5NN' OR '5NV' OR '5PV' OR '5PW' OR '5PZ' OR '5Q3' OR '5Q6' OR '5QJ' OR '5QX' OR '5QZ' OR '5R5' OR '5R8' OR '5RD' OR '5RG' OR '5S1' OR '5SB', 4,' OR ', 1, ',', 4109, A4109);
-TYPE



Thanks,
Sathish

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

Hey Sathish,

For the STRREP function there is a string size limit of 4,095 bytes.

quote:

Reference: Usage Notes for STRREP Function
The maximum string length is 4095.

Also I found your example above to work better when the "A4109" was placed within single quotes.

  
-SET &STRLEN = &ACCESS.LENGTH;
-SET &VERBOBJ = STRREP(&STRLEN, &ACCESS, 4,' OR ', 1, ',', &STRLEN, 'A&STRLEN.EVAL');

If your string is too long, you may have to do it in parts and then put them back together.