
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Split string field into table rows
Hiya,
I have a data set that has about 40 columns and one of those has 'Enquiry Numbers' which can hold 1-x amount of numbers, which I would like to split out, for example:
ID | Enquiry Number
123 | 15, 25, 68, 52
124 | 2, 98, 34, 76
126 | 18, 24, 88, 92, 48
127 | 5
128 | 92, 16
and so on and so forth, what I would like to is split each Enquiry and have it pull in all the table data for that ID but only one of the Enquiry Numbers.
I've found this post with an answer: Suggested Solution
However, the answer shows that you need to repeat the solution for each part of the field that needs splitting.
I can have any number of Enquiry Numbers in this field, so don't want to have to repeat the process 50 times just to capture them all.
Is there a better way?
Thanks in advance
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think the best way to create multiple rows out of one field is subfield function. In the script if we use something like subfield([Enquiry Number],','), It should create multiple row dynamically for each value separate by comma.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think the best way to create multiple rows out of one field is subfield function. In the script if we use something like subfield([Enquiry Number],','), It should create multiple row dynamically for each value separate by comma.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Omg, perfect! That has worked perfectly thank you so much!!!
