I need to replace the input variable according to a desired format. For example acct has values incoming as '1204' and want it to like 1204. One more case, if the input is multiple , like '1204' OR '1205' OR '1206' then need the desired output as 1204,105,1206

Thanks in advance for the help.

Regards,
Sourabh

This message has been edited. Last edited by: <Kathryn Henning>,

If this is form HTML Composer, read this. If not search STRREP.

Look up EDIT and RJUST

We can remove those quotes using CTRAN. Here is something that I use when passing multiple values into SQLPASS THRU

-PROMPT &CAR.(OR(FIND CAR IN CAR)).Car.;
-SET &CAR = STRREP(&CAR.LENGTH,&CAR,4,' OR ',1,',',&CAR.LENGTH,'A&CAR.LENGTH') ;
-SET &CAR = TRUNCATE(&CAR) ;
-TYPE &CAR;
-SET &CARIN = '(' |&CAR |')' ;
-SET &CARIN = TRUNCATE(&CARIN);
-TYPE &CARIN;
-SET &CAR_NC = TRUNCATE(&CAR);
-TYPE &CAR_NC ;
-SET &CARNC = CTRAN (&CAR_NC.LENGTH,&CAR_NC,39,32,'A&CAR_NC.LENGTH');
-TYPE &CARNC ;
-SET &CARNC = STRIP(&CARNC.LENGTH,&CARNC,' ','A&CARNC.LENGTH') ;
-SET &CARNC = TRUNCATE(&CARNC);
-TYPE &CARNC;
-SET &SQLCAR = IF '&CARNC.EVAL' EQ 'ALL' OR '&CARNC.EVAL' EQ 'FOC_NONE' OR '&CARNC.EVAL' EQ '_FOC_NULL' OR '&CARNC.EVAL' EQ ' ' THEN ' ' ELSE 'AND CAR IN ' | &CARIN ;
-TYPE SQLCAR : &SQLCAR ;

-SET &VAR_IN = '''1204''' | ' OR ' | '''1205''' | ' OR ' | '''1206''' ;
-*
-* Get rid of single quotes
-SET &VAR_OUT1 = STRIP(&VAR_IN.LENGTH , &VAR_IN, '''', 'A50') ;
-* Replace ' OR ' with ','
-SET &VAR_OUT2 = STRREP(&VAR_OUT1.LENGTH,&VAR_OUT1,4,' OR ',1,',',50,'A50');