Please help me 🙂
I have two tables each with only one relevant column
Table1.Paragraph
50,000 paragraphs of text
Table2.Firstname
4,000 names
I want to retrieve any paragraphs which contains a name from the firstnames list although the names could be anywhere inside the paragraph.
I only have MS Access 2010.
Something like this?
SELECT Table1.Paragraph From Table1 where Paragraph IN(Select %Firstname% from Table2)???
Any suggestions would be greatly appreciated! 🙂 Cheers in advance
Do you have these indexed in Splunk already?
Perhaps this page may give some guidance;
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/SQLtoSplunk
/K
This the user forum for the Splunk product. Most likely, Splunk can do what you want it to do with your data.
Good Luck, K
maybe I've misunderstood here - I dont know what splunk is - i thought it was a forum
Thanks Kristian for replying 🙂 However I don't really understand what you mean
Use Splunk instead of MS Access 🙂