What I’m trying to do
I’m trying to filter out links within metadata.
I have a set of questions that may or may not be in the same file. I have different answers to those questions from different people. I’m trying to pull out the questions and answers for a particular person.
#questions
question::Question # 1?
answer::Answer 1.1 [[Person 1]]
answer::Answer 1.2. [[Person 2]]
question::Question # 2?
answer::Answer 2.1. [[Person 1]]
answer::Answer 2.2. [[Person 2]]
Desired Results:
| Question | Answer |
|Question # 1? | Answer 1.1. [Person 1] |
|Question # 2? | Answer 2.1. [Person 1] |
Things I have tried
The following examples show No Results:
Ex. 1
table question, answer
from #questions
where contains(answer, [[Person 1]])
Ex. 2
table question, answer, file.outlinks
from #questions
where contains(file.outlinks, “[[Person 1]]”)
Ex. 3
table question, answer, file.outlinks
from #questions
where contains(file.outlinks, “Person 1”)
Ex. 4
table question, answer
from #questions
where contains(string(file.outlinks), “[[Person 1]]”)
Ex. 5
table question, answer
from #questions
where answer = “[[Person 1]]”
Ex. 6
table question, answer
from #questions
where answer = [[Person 1]]
Ex. 7
table question, answer
from #questions
where file.outlinks = [[Person 1]]
Ex. 8
table question, answer
from #questions
where string(file.outlinks) = “[[Person 1]]”
The following examples show both people’s results.
Ex. 1
table question, answer
from #questions
where contains(answer, “[[Person 1]]”)
Ex. 2
table question, answer
from #questions
where contains(file.outlinks, [[Person 1]])
Ex. 3
table question, answer
from #questions
where contains(string(file.outlinks), “Person 1”)