Using SPLIT() to put text in 2 columns

[1minManager]

I’m tring to use Appsheets SPLIT() function like Googles. I want to split a line of text into 2 column with the sperator being tilde. i.e.

Column A = 123~ABC
Column B = 123
Column C = ABC

Main problem is as soon as it splits, it creates a 2 item list, which has to be in a virutal column.

Whereas =SPLIT(F27,"~") works as expected in Google Sheets

Anyone know how to achieve the above in Appsheet? To keep it simple, the string will only ever be 2 items sperated by a tilde

[Suvrutt_Gurjar]

Hi @1minManager,

Does it help to have an expression something like below for column B
INDEX(SPLIT([Column A],"~"),1)

and Column C expression as

INDEX(SPLIT([Column A],"~"),2)

[1minManager]

Awesome @Suvrutt_Gurjar that works perfectly

Simon@1minManager.com

[Suvrutt_Gurjar]

Hi @1minManager
Thank you for the update. Nice to it works as per your requirement.