Extract first names from List-user field.
A bit of a mystery to me: The List-user field is called [Activity - Advisor]. From that field, I want to extract the first names. When I make the formula as: List(", ", Left(Part(ToText(UserListTo...
Forum Discussion
List(", ",
Left(Trim(Part(ToText(UserListToNames([Activity - Advisor])),1,";"))," "),
Left(Trim(Part(ToText(UserListToNames([Activity - Advisor])),2,";"))," ")
)
Left(Trim(Part(ToText(UserListToNames([Activity - Advisor])),1,";"))," "),
Left(Trim(Part(ToText(UserListToNames([Activity - Advisor])),2,";"))," ")
)
I am loving it - you helped me find an error in my grammar! I had the function User listed ahead of UserListToNames in my grammar so the parser was trying to match on the opening parenthesis.
https://pastebin.com/TQGE65ZG
I am going to write a script that will extract all the formulas from an application so I can run them through my grammar as test cases. Then I will invite everyone to send me their formulas so I can run 10,000 test cases.
https://pastebin.com/TQGE65ZG
I am going to write a script that will extract all the formulas from an application so I can run them through my grammar as test cases. Then I will invite everyone to send me their formulas so I can run 10,000 test cases.