URL Address

[Anonymous]

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,

[MayilVahanan]

Hi

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

[Anonymous]

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

Double numbers

[MayilVahanan]

Hi

     Did u try like as mentioned?

[Anonymous]

Yes, I copied it even.

it works, but with duble numbers.

[MayilVahanan]

Hi

Can you post your file?

[Anonymous]

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

[Anonymous]

Please see my attached file.

[MayilVahanan]

Hi

     Try like this..

     Hope it helps

[Anonymous]

No, I lost many URL

They have the same URL, but different NUMBERS.

[MayilVahanan]

HI

Check this . Let me know whether its correct or not