topic Re: Create a New Variable from part of another string variable? in QlikView

Create a New Variable from part of another string variable?

Tue, 21 Apr 2015 18:27:36 GMT

Basically I have a variable that is a URL. Sometime it starts with http://. Other times it will start with https:// or www.

I basically want to create a Host Name variable from the URL variable.

http://hostone/addtexthere

http://hostone/moretextstuff/here

www.hostone/text/morestuff

http://hosttwo/stuff/here

The top three would be put classified as the same Host Name (Host One) based on the "hostone." The bottom one would be put in Host Name (Host 2) based on the part of it that says "hosttwo"

I am very much unsure how to go about this in Qlikview. Can anyone help me out here?

Re: Create a New Variable from part of another string variable?

Anonymous — Tue, 21 Apr 2015 20:41:17 GMT

can you give example what should be stored in your new variables?

hostone\...

hosttwo\...

did you check the stringfunctions. they may help you

if you explain the outcome, it's easier to get help

Re: Create a New Variable from part of another string variable?

marcus_malinow — Tue, 21 Apr 2015 20:53:59 GMT

try this substituting in your URL

subfield([Your URL], '/', 3)

Re: Create a New Variable from part of another string variable?

Anonymous — Tue, 21 Apr 2015 21:34:58 GMT

Assuming the URL always contains either hostone or hosttwo:

if(index(URL,'hostone'), 'Host One', 'Host Two')

Re: Create a New Variable from part of another string variable?

Wed, 22 Apr 2015 15:23:27 GMT

Basically what I want stored in my new variable would just be the host name. So the part that is after the www. but before any of the slashes.

So for the example I gave above I would want hostone and hosttwo to be what is stored in the new variable.

Re: Create a New Variable from part of another string variable?

Wed, 22 Apr 2015 15:31:18 GMT

Yeah, I used hostone and hosttwo as a basic example, but with the data I'm working with I will likely have over 40 hosts.

Re: Create a New Variable from part of another string variable?

Anonymous — Wed, 22 Apr 2015 15:54:55 GMT

Let me try another way:

'Host ' & capitalize(textbetween(URL, 'host', '/'))

Re: Create a New Variable from part of another string variable?

Wed, 22 Apr 2015 20:10:14 GMT

Thank you, I'm a new user and was unaware of the textbetween() function! This worked perfectly for what I wanted, thank you!