Can anyone help me understand how to do a STRREP when I am trying to replace a single quote mark (')?

Thank you,

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

More background info about your need would be useful but hopefully the sample code below can give you some ideas:

DEFINE FILE CAR
NAME/A10 WITH CAR = 'O''Connor';
NEW_NAME/A10 = STRREP (10, NAME, 1, '''', 1, '*', 10,  NEW_NAME);
END
TABLE FILE CAR
PRINT NAME AND NEW_NAME
WHERE RECORDLIMIT EQ 1
END

Here is some more information. All of my data is right justified. I am trying to create a multiselect box with the values of A, B, C. But I need the fields to read ' A', ' B', ' C'. If I select A and B from my multiselect box the value is 'A' or 'B'. I need to modify this field to make it read like ' A' or ' B'.

Why not have the values in the multi-select contain that first-character blank? The blank would be passed within the variable.

How are you populating the multiselect box? If it's with static values entered from the Composer, the line of code renders like this:

<OPTION selected value=" A" noinput="0" displaytext=" A">A</OPTION>

If you're populating it via a fex, it should work as well.

MSmoger,

I have come up with this solution if you would like to give it a try:

-SET &NAME = ' ''A'' OR ''B'' OR ''C'' ';
-SET &NLEN = &NAME.LENGTH + 3;

-SET &NNME = STRREP ( &NAME.LENGTH, &NAME, 2, ' ''', 3, ' '' ', &NLEN.EVAL,  'A&NLEN.EVAL');

-TYPE &|NAME = &NAME
-TYPE &|NNME = &NNME

I set -SET &NAME = ' ''A'' OR ''B'' OR ''C'' ';
to have extra quotes around it for testing in the DS Editor.

If you have a string of A,B,C being passed it will most likely be like: 'A' OR 'B' OR 'C'.

I will give this a try. Thank you.