Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Maybe like
=Replace( PurgeChar( vVariable ,chr(39) ),',',';')
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
Like this?
Exactly! Works like a charm. Thanks a million.
Best regards,
-Eduardo