-SET &listsec_as = IF &listsec_as.LENGTH GT 3 THEN STRREP(&listsec_as.LENGTH,&listsec_as,14,'Comp_Qualifier',142,'case when component_qualifier.qualifier IS NULL THEN ' NONE' else component_qualifier.component_qualifier end AS Component_Qualifier',300,'A300') ELSE &listsec_as;


As ' NONE' is in the quotes, i am not able to pass this string as a replacement string.
Please help, how can i replace this string in STRREP function.

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

-SET &listsec_as = IF &listsec_as.LENGTH GT 3
-                  THEN STRREP(&listsec_as.LENGTH,
-                              &listsec_as,14,
-                              'Comp_Qualifier',
-                              142,
-                              'case when component_qualifier.qualifier IS NULL THEN ' | ''' NONE''' | ' else component_qualifier.component_qualifier end AS Component_Qualifier',
-                              300,
-                              'A300')
-                  ELSE &listsec_as;

This might be a start.

FYI:

In FOCUS code two single quotes in Diaglog Manager (dash commands) in a quoted string equals one single quote.

e.g.

-SET SingleQuote = '''' ;
-SET InString = 'I Don''t Like Mondays' ;