Multiple Choice paramater usage in custom SQL with "IN" condition - remove quotes

Hi @raskarov,

It seems that there is no way to copy-paste values from an Excel column to a “Text or Number” parameter since it doesn’t support line breaks.

As for wrapping values in quotes, if you can be sure that your values don’t contain commas and quotes, you can try to use a calculated parameter with the following expression:

"'" & replace({Invoices}, ", ", "', '") & "'"

But with this expression, you have to be very consistent with the space characters between commas and values. The number of space characters should always be the same and match the number of space characters in the second argument of the replace() function. You can add a validation rule to the initial parameter that will check that values have the expected number of spaces between commas and adjacent values. Something like this:

Or you can try to remove spaces between commas and values with a sequence of replace() functions.

Here is an example project: WrapParameterValuesInQuotes.morph (2.2 KB)