topic Re: URL Address in QlikView

URL Address

Anonymous — Tue, 11 Sep 2012 20:49:59 GMT

Hi,

Please help me with idea.

I have different website' urls like this http://www.name.org/site/lookup.asp?c=9iLOK7PJKfI2G&b=6229577.

I want to keep only name.org.

I replace in load scrypt

Replace(Replace(Replace(Replace(Replace(SITE, 'http://',''),'http:/',''),'http:www.',''),'https://',''), 'www.','') as ...

I get name.org/site/lookup.asp?c=9iLOK7PJKfI2G&b=6229577

How can I replace or remove other info after org?

Thanks,

Re: URL Address

MayilVahanan — Tue, 11 Sep 2012 21:03:27 GMT

Use KeepChar('

http://www.name.org/site/lookup.asp?c=9iLOK7PJKfI2G&b=6229577','name.org')

Hope it helps

Re: URL Address

jagan — Wed, 12 Sep 2012 07:45:56 GMT

Hi,

Try this

=Left(Replace(URLFieldName, 'http://www.', ''), index(Replace(URLFieldName, 'http://www.', ''), '/')-1)

Hope this helps you.

Regards,

Jagan.

Re: URL Address

Anonymous — Wed, 12 Sep 2012 14:19:37 GMT

Hi guys,

Your ideas didn't work as I need it.

Please see my url example below

headandqqq.ca/en-CA/index.jspx_049708

headandqqq.co.in/en-IN/index.jspx_051205

headandqqq.com/en-US/index.jspx_049647

headandqqq.com/es-US/index.jspx_049713

helpcer.linkshare.com/publisher_024374

ihotel.com/ihg/hotels/us/en/global/support/meetings_106328

I want to keep everything included domain and _NUMBERS

Re: URL Address

jagan — Wed, 12 Sep 2012 14:54:20 GMT

Hi,

Can you clearly explain with some example. Earlier you said that you need only "name.org", so the script which I given works you.

Input:

ihotel.com/ihg/hotels/us/en/global/support/meetings_106328

Output:

ihotel.com/_106328

Is this you require?

Regards,

Jagan.

Re: URL Address

Anonymous — Wed, 12 Sep 2012 14:57:02 GMT

Sorry for confusing,

Yes,

Input:

ihotel.com/ihg/hotels/us/en/global/support/meetings_106328

Output:

ihotel.com/_106328.

Cheers,

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 15:27:26 GMT

Try something like this,

= SubField('ihotel.com/ihg/hotels/us/en/global/support/meetings_106328','/') &'/_'&

SubField('ihotel.com/ihg/hotels/us/en/global/support/meetings_106328','_',2)

This also give o/p as your requirement

Re: URL Address

Anonymous — Wed, 12 Sep 2012 17:12:57 GMT

It didn't work.

I need to replace all of them.

Different url with differnt numbers at the end.

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 17:20:23 GMT

Please see the attached file

Re: URL Address

Anonymous — Wed, 12 Sep 2012 17:48:19 GMT

Please see atached file. Your expression works!!!

But I replaced first part. Could you adjust it?

Thanks,

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 18:01:03 GMT

Please check the attached file..Is one of the way to achieve your requirement

Re: URL Address

Anonymous — Wed, 12 Sep 2012 19:23:04 GMT

I don't understand why when I load my data, I got URL address_NUMBER/_NUMBER?

Double numbers

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 19:26:57 GMT

Did u try like as mentioned?

Re: URL Address

Anonymous — Wed, 12 Sep 2012 19:42:58 GMT

Yes, I copied it even.

it works, but with duble numbers.

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 19:48:02 GMT

Can you post your file?

Re: URL Address

Anonymous — Wed, 12 Sep 2012 19:49:35 GMT

I load data from csv format. Maybe it's problem?

Re: URL Address

Anonymous — Wed, 12 Sep 2012 19:52:25 GMT

Please see my attached file.

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 20:11:23 GMT

Try like this..

Hope it helps

Re: URL Address

Anonymous — Wed, 12 Sep 2012 20:28:41 GMT

No, I lost many URL

They have the same URL, but different NUMBERS.

Re: URL Address

MayilVahanan — Wed, 12 Sep 2012 21:21:32 GMT

Check this . Let me know whether its correct or not