Using Action Select in Field with Concat

[Anonymous]

I'm trying to select a field based on the selection of a different data table.  I can get it to work as long as the selection doesnt have a space in it. 

In the attached example of names, they all work except for 'John R'.  That's the only one with a space.  Is there a solution to this or do I need to remove all spaces from my data?

[maxgro]

just add double quotes

='("'&Concat(Distinct Name1Value,'"|"')&'")'

//'('&Concat(Distinct Name1Value,'|')&')'

[Anonymous · Accepted solution]

Works thanks.  What does the double quotes do and what determines placement of them?

[maxgro]

double quotes?

when you have space in values, John R --> "John R"