Help

LookUp and unwanted splitted data because of comma

Topic Labels: Data
Solved
Jump to Solution
380 2
cancel
Showing results for 
Search instead for 
Did you mean: 
lmeinert
5 - Automation Enthusiast
5 - Automation Enthusiast

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 !

1 Solution

Accepted Solutions
lmeinert
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

See Solution in Thread

2 Replies 2
lmeinert
5 - Automation Enthusiast
5 - Automation Enthusiast

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

lmeinert
5 - Automation Enthusiast
5 - Automation Enthusiast

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.