I want to split a text field by the space character, then I want to access the first and second items in the list. The help text for the split command says" "Converts text string, in format of items list with custom separator character, to list structure. Each item can be processed separately." I am assuming that means I can access each part separately by index or something simular, but I cant figure it out.
Here is my code:
var textList name = Split([Attached Company Name], " ");
"FIN" & $name[0]
The code does not work, it doesn't like me trying to access the zero index of the $name text list. How do I access the first element of list without knowing what it is and without using the string cutting functions (Mid / Left / Right)
------------------------------
Steve Wellauer
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.