Remove single quotes and change separator in a list of comma separated values

[#1]

Hi there,

In Settings / Variable Overview I've created a variable with the following value:

'Option_1', 'Option_2','Option_3'

How can I convert this value to the following:

Option_1;Option_2;Option_3

As you can see, the single quotes should be gone and the separator needs to be changed from a comma to a semicolon.

Thanks in advance for any help,

-Eduardo

[swuehl]

Maybe like

=Replace( PurgeChar( vVariable ,chr(39) ),',',';')

[#3]

Thanks swuehl, this expression does convert the string perfectly. However, I need to use this in an input box object (Drop-down). The Drop-down should display the items in the variable as the Drop-down items. If I enter the expression in the Listed Values field in the Constraints tab of the object properties, the Drop-down shows a single item which is the converted string.

Am I missing something?

Thanks in advance for all your help,

-Eduardo

[swuehl · Accepted solution]

Like this?

[#5]

Exactly! Works like a charm. Thanks a million.

Best regards,

-Eduardo