Hi, How do extract and compare exact arrays from two tables?
I'm trying to compare listed numbers from two different arrays one being the 'current talk selection' from a table setup called 'speaker' and the other 'T#' from a table called 'talks'
for example the array 'current talk selection', would list numbers 02,44,114
The other array 'T#' which is a field in a table called 'Talks' Which lists the talk numbers 1 to 200 (so I have a id before the title of the talk) eg. 02{T#} talk title{title}
using this formula it does list the selected numbers but also includes 01 04 11 14 (I'm guessing because of numbers 44 and 114)
this is the formula :
let c := text('Current talk selection'); {in this case it would be 02,44,114}
let a := text('T#'); {gets the number from a table called 'Talks' with a field called T#}
extractx(c, a)
how do I list just the numbers in the 'current talk selection' array please
1 reply
Content aside
- 4 yrs agoLast active
- 1Replies
- 799Views