You’re offline. This is a read only version of the page.
Announcements
Hello! I have a table that contains:
| Names |
| Apple - Pomme |
| Banana - Banane |
| Tomato - Tomate |
| Kiwi - Kiwi |
I would like to have a table that says:
| Names | Noms |
| Apple | Pomme |
| Banana | Banane |
| Tomato | Tomate |
| Kiwi | Kiwi |
How to I use the split function to achieve this?
Thank you!!
@Anonymous
In general, the formula would be:
Share
Report
All responses (
Answers (
76,297
ForAll(
Table1,
With({_results: Split(Names, "-")},
{Names: Trim(First(_results).Result),
Noms: Trim(Last(_results).Result)
}
)
)
The above formula will return a table with the columns and values as you require.
I hope this is helpful for you.
