LookUp and unwanted splitted data because of comma

[lmeinert]

Hey guys,

I'm creating a competency framework.
I've these tables :
- Jobs (lookup to "Competencies" table)
- Competencies (6000 rows) with macro-competencies in column 2 (multiselect)
- Macro-Competencies (600 rows) (isolated from but not linked to "Competencies")

I'd like to re-create the link/lookup between "Competencies" and "Macro-Competencies" tables. 

I tried to replace the multiselect field "Macro-Competencies" in "Competencies" table by a LookUp field and the replacement looks good EXCEPT when Macro-Competencies fields contains a COMMA. Then, there is an (unwanted) "auto-split".

Is there a way to AVOID this split when there is a comma into the datas ? 

Thanks in advance !

[lmeinert]

I tried to add brackets around a macro-competency name containing a comma in "Macro-Competencies" table but it doesn't change anything. 

[lmeinert · Accepted solution]

I found how to resolve this !

I had to add brackets arounds names with a comma BUT inside the multi-select in "Competencies" table before doing the lookup.