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
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)
Awesome @Suvrutt_Gurjar that works perfectly
Hi @1minManager
Thank you for the update. Nice to it works as per your requirement.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |