Can Appsheet have the column filled up automatically based on a long text?

[Ahmad-Luthfi]

Hi,

I am in the middle of experimenting whether if appsheet can autofill columns based on 1 input in long text format.

As example, let say I have a submission of as below:

"Name: Ahmad Luthfi

Age: 41

Address: Malaysia, Earth"

From the long text above, I was wondering if there is any function that we can use to fill up columns named "Name", "Age" and "Address" so that we have single line data.

In excel format, I can use SPLIT function and using ":" as the split criteria, then I will use IF and VLOOKUP based on "Name", "Age" and "Address".