Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm hoping to find a way to find and pull specific links out of twitter posts. I have the list of links I am looking for, but I'm having trouble finding a way to search and pull them out of the text string.
I know that I can use WildMatch to find them with something like the below
WildMatch(Tweet,'*Link1*','*Link2*','*Link3*')
and then mapping that to a table that would look like the following.
Mapping Table
Generic Load
1, Link 1
2, Link 2
3, Link 3
What I was hoping to do was replace the '*Link1*','*Link2*','*Link3*' part with something more dynamic, so that it wouldn't have to contain 50+ links that I would have to match up exactly to the mapping table.
Edit: To summarize, what I am trying to do is look through a string of disourganized text to see if it contains another piece of text within a table, and if so return that text from the table.
Any ideas?
Hi, Found the following link and hope it will help. http://community.qlik.com/message/88469#88469 Regards. siva sankar
hi Siva,
Unfortunately that problem was slightly too simple to provide any help. What I'm looking to do is find a set of possible terms within a text string and isolate them, not just replace the name of set text categorizations.
Thanks anyway though!
Hi,
Have a look at my solution to this post - http://community.qlik.com/message/221951#221951
Essentially, you need to use a variable that dynamically builds the comma delimited values to pass to the WildMatch() function.
Hope this helps,
Jason