Paste and Select - Variable Input and Button Action

[AJ2024]

Users need to be able to paste a list of values from excel and use those values as selections in a field. I have seen examples of this done using variable input and a button with select action.

In my use case, however, only values that contain text characters are being returned. Values that only contain numbers are being ignored in the selection process. 

Here is my current setup:

1. Variable input box to set: vMemberID_Selection

2. Button Action: Select values in a field

3. Button Field: PRIMARY_MEMBER_ID //text field

4. Button Value: =replace(vMemberID_Selection,' ',';') //replace the empty space delimiter from excel with a semi-colon

When I paste the below list from excel, only the first 3 values are returned for PRIMARY_MEMBER_ID. The last two values that only contain numbers are ignored.

PER-12345678;ORG-12345678;EMP-dsvo3sdf6sdfs48fs4;23456789;34567890

I have also tried manually converting the Button Value to text but still experienced the same behavior:

=text(replace(vMemberID_Selection,' ',';'))

=replace(text(vMemberID_Selection),' ',';')

Any ideas what could be causing this issue and how to resolve?

[RonaldDoes]

Hi AJ,

I find this to be working for your case:

='$(=Replace(vMemberID_Selection, ' ', ';'))'

Please find the attached QVF for an example.