Skip to main content
Solved

LookUp and unwanted splitted data because of comma

  • August 17, 2023
  • 2 replies
  • 28 views
L
Forum|alt.badge.img+3

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 !

Best answer by lmeinert

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. 

    2 replies

    L
    Forum|alt.badge.img+3
    • lmeinert
    • Author
    • New Participant
    • 2 replies
    • August 17, 2023

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

    L
    Forum|alt.badge.img+3
    • lmeinert
    • Author
    • New Participant
    • 2 replies
    • Answer
    • August 17, 2023

    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. 


    Terms & ConditionsAccessibility statement