Getting Index of Array

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

2 Likes

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

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.