Welcome to the Airtable Community!
When pasting text into single line text fields, Airtable uses tabs to split text in a single line into different fields. Can you edit your text to replace the first comma and space in each line with a tab character? If your text is very short, this might be the easiest method.
Another option is to paste the text into a single field, use formula fields to split the text into two different fields, and then finally convert the formula fields into plain text. This method works well if you are comfortable creating formula fields.
Here are some formulas where {String}
is the initial field that contains the complete line.
Formula for the line number:
LEFT(
{String},
FIND(",", {String}) - 1
)
Formula for the dialogue
RIGHT(
{String},
LEN({String}) - FIND(",", {String}) - 1
)
If you need an ongoing process, you might want to look into other methods.
Welcome to the Airtable Community!
When pasting text into single line text fields, Airtable uses tabs to split text in a single line into different fields. Can you edit your text to replace the first comma and space in each line with a tab character? If your text is very short, this might be the easiest method.
Another option is to paste the text into a single field, use formula fields to split the text into two different fields, and then finally convert the formula fields into plain text. This method works well if you are comfortable creating formula fields.
Here are some formulas where {String}
is the initial field that contains the complete line.
Formula for the line number:
LEFT(
{String},
FIND(",", {String}) - 1
)
Formula for the dialogue
RIGHT(
{String},
LEN({String}) - FIND(",", {String}) - 1
)
If you need an ongoing process, you might want to look into other methods.
Thank you so much Kuovonne! I didn’t realize that Airtable used tabs to split cells on paste. We can definitely put tabs into the text file so it will paste nicely. Thank you!