Vincent_Weselak - profile

Vincent_Weselak · Feb 26, 2020

I would like to separate a look up field (values separated by commas) into separate cells. I have information from Table 1 linked to Table 2 (Junction Table) that is linked to Table 3. Table 3 has a look up field (puling information form Table 1 to T...

Vincent_Weselak · Feb 27, 2020

Thanks for the reply. I found a similar formula used for excel that worked utilizing SUBSTITUTION function and MID function. MID({Field1},FIND(“CHAR(1)”,SUBSTITUTE({Field 1},",",“CHAR(1)”,1))+2,FIND(“CHAR(2)”,SUBSTITUTE(Field 1},",",“CHAR(2)”,2))-2-F...

User Statistics

User Activity

Separate a Look Up field (separated by commas) into separate cells

Re: Separate a Look Up field (separated by commas) into separate cells