Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Parsing data of a string separated by ","

286 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I will need to separate the data from a “lookup” column nammed “Response (from SMS Responses)” which gives me the list of poll results as numbers (between 1 and 5 or a comment) :
image_2022-03-22_001928

I tried formulas like this:
LEFT({Response (from SMS Responses)}, 1)

Or this one:
LEFT({Response (from SMS Responses)}, FIND(",", {Response (from SMS Responses)}) -1)

But I always come across errors, what could I do?

Thanks in advance !

1 Reply 1

Welcome to the Airtable community!

This is the source of the issue. The lookup appears to be a comma separated text string, but it is not. It is an array.

One method of dealing with this is to force the lookup to be a text string in your formula:

LEFT({Response (from SMS Responses)} & "", 1)

On the other hand, this will not work well because there is no actual comma in the resulting text string.

Recommend that instead of trying to parse this lookup, look into using

  • a new conditional lookup/rollup field
  • a rollup field