Alternative to Index Match (Match)

[Hunter_Casillas]

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.

[Julian_Kirkness · Accepted solution]

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

[Hunter_Casillas]

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