Convert Text into Multiple Airtable Rows


I am looking to convert numbered Text into multiple rows in Airtable.
Example: Chat GPT will give me an output of text like: 1. Item 1 2. Item 2 3. Item 3. but if I send that to airtable it will put all the text in 1 row.
Is there a way to have each numbered item put in it’s own row?

Thank you in advance!


If possible, I would include in the prompt to format the output by separating the items with something like a line break. If items are separated by line break by ChatGPT then that’s all you’d need to do.

If that’s not possible, then you could use a Text Parser Match Pattern module and use a regular expression to pull each item then use a text aggregator to put them all back together with each on a separate line.


Another option is to use a Text Parser Replace module using a regular expression to replace each occurrence of "#. " with a newline character.
This would leave you with something like:
Item 1
Item 2
Item 3

Then, split those by newline to give you an array of those items.
Iterate through them and use a Text Parser to number them again.
Please see attached blueprint for an example of this.
It wouldn’t work correctly if one of the items happens to contain a number followed by period and a space.
regex replace.json (7.5 KB)


Worked great, thank you so much Donald you are a godsend!