0

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

null
    • Window cleaner
    • Phil_B
    • 3 yrs ago
    • Reported - view

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 789Views