
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 26, 2020 08:38 AM
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 Table 2 into Table 3). The values in the look up field are separated by commas. (I am having a problems applying formulas to the look up field).
Is it possible to separate these values into separate fields?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 02, 2022 01:46 PM
Not sure although it might have to do with emoji actually being composed of multiple characters.
However, I still think a scripting option is now better than a formula.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 06, 2023 12:37 PM
This "concatenating" hack wont work if there are multiple matches in the lookup field.
See what happens below:
 
As you see, the IDs are combined. I need them to remain split either by comma or anything else unique so that I can separate ID's into different fields as you outline above.
 
 Do you have any possible suggestions here?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 06, 2023 12:43 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2023 12:32 PM
Have you found a way to deal with this yet? I just run into this and I could not figure out what the issue was until I found your comment.

- « Previous
- Next »