Split or Inverse expresion of Cocatenate? Help with Expressions

AppSheet AppSheet Q&A
1

I have a column that is a Key. A Concatenate of two colums: CONCATENATE([Racing Date],": ",[Track]). So in F.E. 23/08/2021 : CHURCHILL DOWNS.

Is there any formula for a virtual column to extract the Date?

2

This?

INDEX(SPLIT([column], ": "), 1)

Replace column with the name of the column containing the concatenated value.

2 Likes