Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

4 Replies
swuehl
MVP
MVP

Maybe like

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

Not applicable
Author

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
MVP
MVP

Not applicable
Author

Exactly! Works like a charm. Thanks a million.

Best regards,

-Eduardo