How to split text string in a data source, so it shows as a choice field in the app?
I have a data source, where one column has a series of information. Example attached.
The description column shows per row a series of line items: 12 | A - 099 | 1 12 | B - 099 12 | C - 099
Where the first description is 12 | A - 099 | 1
the second 12 | B - 099
and the third 12 | C - 099
Each line item contains a pipe separator "|" and between descriptions there's space " ". Since space is available inside each description, thus not unique, I wonder if it's possible to split the text by using the very first info before the first pipe separator. In our example, "12".
Perhaps there's a formula that I could use?
Any help would be much appreciated.