Skip to main content

Hey there,


I’ve already converted my array into a string, and each value is separated by a comma. It looks like this:


2019-12-23T00:00:00.000Z, 2019-11-23T00:00:00.000Z, 2019-12-27T00:00:00.000Z, 2019-11- 

23T00:00:00.000Z, 2019-11-24T00:00:00.000Z

I understand that Airtable doesn’t have index functionality, so how would I achieve this individually for each value? I’ll be splitting these up into 5 individual fields within my table.


I know there are other topics on this, I couldn’t find the solution I was looking for on those. Thank you so much for your responses.

Hi


If your issue is how to get these values into the separate fields, then I think you’l have to simply use the MID() function to split this up into your five separate fields (are there always 5 values??). You can do this because you know how long each value is (24 characters if I counted correctly). The second value, for example, would be:


MID({Field 13},27,24)


Where field 13 holds your string.


Hope this helps

Hi


If your issue is how to get these values into the separate fields, then I think you’l have to simply use the MID() function to split this up into your five separate fields (are there always 5 values??). You can do this because you know how long each value is (24 characters if I counted correctly). The second value, for example, would be:


MID({Field 13},27,24)


Where field 13 holds your string.


Hope this helps


Wow, can’t believe I didn’t see this, thank you!

Terms & Conditions