Hello,
So, is multivalue the only way to use list/array?
If I want to assign 7 values, should I use mvappend 7 times like the following?
| eval test = mvappend("0", test)
| eval test = mvappend("1", test)
| eval test = mvappend("2", test)
| eval test = mvappend("3", test)
| eval test = mvappend("4", test)
| eval test = mvappend("5", test)
| eval test = mvappend("6", test)
How do I get true/false return if I want to see if number 5 is in the array/list?
MVfind only give me the position of 5, which is 1.
| eval n = mvfind(test, "5")
Thank you
You can "nest" mvappends to add multiple values at once. You can also use split() to make a multivalued field from a string of delimited values.
You can use isnull() to check if mvfind returned a value or not.
One caveat about mvfind though - it matches based on regex so you might get some unexpected results if you're not careful