topic Re: Finding and pulling out text within a text string in QlikView

Finding and pulling out text within a text string

Wed, 20 Jun 2012 15:29:30 GMT

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?

Re: Finding and pulling out text within a text string

Siva_Sankar — Wed, 20 Jun 2012 15:52:27 GMT

Hi, Found the following link and hope it will help. http://community.qlik.com/message/88469#88469 Regards. siva sankar

Re: Finding and pulling out text within a text string

Wed, 20 Jun 2012 16:34:11 GMT

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!

Re: Finding and pulling out text within a text string

Jason_Michaelides — Wed, 20 Jun 2012 19:30:05 GMT

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