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".

[dbaum]

SPLIT

INDEX

[ChristianLi]

Name:

Left(Index(Split([text],": "),2),len([text])-4)

Where split() return an array, index()-ing the second position would be "Ahmad Luthfi Age". Left() then splices the text by returning only a certain number of character thus len() or length of the text. Where minus 4 means not including " age".

As so likewise with the age by indexing 3 and subtracting 8 on the len(). 

Address is straght forward by index()-ing 4, no need to use left().

Edit: u could also consider TRIM() to remove spaces. Apologise no back links typing on mobile.

[dbaum]

FYI, here's a basic template using a split-last-split-first technique where you don't have to worry about length.

INDEX(SPLIT(INDEX(SPLIT([Text], "Name:"), 2), "Age:"), 1)

[ChristianLi]

Awesome @dbaum! intresting how we could utilize split() this way.

This is definitly much more precise.