number of elements in a list for an expression
number of elements in a list for an expression
(OP)
I am using the SplitString function in expression and I would like to know how many elements I have in the resulting list that is created. for example (SplitString( XX-XX, "-" ) would result in {XX,XX} . I would like to know how many times the string was split.





RE: number of elements in a list for an expression
You can use the length() function to get the number of times the string was broken. Length() gives the overall number in the list generated by the substring function.
So for example if you have a string variable test = "engtips"
then you can directly get the total number of letters (including spaces) by using
LENGTH(SUBSTRING(TEST,""))
Hope this is what you were looking for.
Best Regards
Kapil Sharma
RE: number of elements in a list for an expression