topic Re: Remove single quotes and change separator in a list of comma separated values in QlikView https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155453#M909617 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Am I missing something?</P><P></P><P>Thanks in advance for all your help,</P><P></P><P>-Eduardo</P></BODY></HTML> Thu, 09 Jun 2016 14:35:21 GMT 2016-06-09T14:35:21Z Remove single quotes and change separator in a list of comma separated values https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155451#M909615 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>In Settings / Variable Overview I've created a variable with the following value:</P><P></P><P></P><P></P><P>'Option_1', 'Option_2','Option_3'</P><P></P><P>How can I convert this value to the following:</P><P></P><P>Option_1;Option_2;Option_3</P><P></P><P>As you can see, the single quotes should be gone and the separator needs to be changed from a comma to a semicolon.</P><P></P><P>Thanks in advance for any help,</P><P></P><P>-Eduardo</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155451#M909615 2020-11-25T16:16:04Z Re: Remove single quotes and change separator in a list of comma separated values https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155452#M909616 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Replace( PurgeChar( vVariable ,chr(39) ),',',';')</P></BODY></HTML> Thu, 09 Jun 2016 11:56:23 GMT https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155452#M909616 swuehl 2016-06-09T11:56:23Z Re: Remove single quotes and change separator in a list of comma separated values https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155453#M909617 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Am I missing something?</P><P></P><P>Thanks in advance for all your help,</P><P></P><P>-Eduardo</P></BODY></HTML> Thu, 09 Jun 2016 14:35:21 GMT https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155453#M909617 2016-06-09T14:35:21Z Re: Remove single quotes and change separator in a list of comma separated values https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155454#M909618 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Thu, 09 Jun 2016 22:44:56 GMT https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155454#M909618 swuehl 2016-06-09T22:44:56Z Re: Remove single quotes and change separator in a list of comma separated values https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155455#M909619 <HTML><HEAD></HEAD><BODY><P>Exactly! Works like a charm. Thanks a million.</P><P></P><P>Best regards,</P><P></P><P>-Eduardo</P></BODY></HTML> Thu, 09 Jun 2016 22:49:19 GMT https://community.qlik.com/t5/QlikView/Remove-single-quotes-and-change-separator-in-a-list-of-comma/m-p/1155455#M909619 2016-06-09T22:49:19Z