Extracting Text between 2 special characters of URL using Excel
 

I Want to extract below info from urls given below.how can i do that in excel. kindly help.

AXIS-IT 532395
AXLESINDIA 40001

http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001

--Vishy

Extracting Text between 2 special characters of URL using Excel
 

On Monday, March 5, 2012 6:02:01 PM UTC+5:30, wrote:
I Want to extract below info from urls given below.how can i do that in excel. kindly help.

AXIS-IT&T 532395
AXLESINDIA 40001

http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001

--Vishy

Extracting Text between 2 special characters of URL using Excel
 

On Monday, March 5, 2012 6:32:01 AM UTC-6, wrote:
I Want to extract below info from urls given below.how can i do that in excel. kindly help.

AXIS-IT 532395
AXLESINDIA 40001

http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001

--Vishy
With a formula, use FIND to locate the "=" and the "http" AFTER the first find. Then use MID

1

Extracting Text between 2 special characters of URL using Excel
 

Hi Vishy,

Am Mon, 5 Mar 2012 04:32:01 -0800 (PST) schrieb :

AXIS-IT 532395
AXLESINDIA 40001

http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001

URL in A1, then:
=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("=",A1)+1,99)," &"," "),"c=",)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Extracting Text between 2 special characters of URL using Excel
 

will u post full formula to extract requested data.

Extracting Text between 2 special characters of URL using Excel
 

Thanks a lot Claus Busch.. it is working but extracted data is like below in single cell.
AXIS-IT T 532395 (Note: & is missed between T&T.)

Can we get extracted data like below in 2 different cells where as first cell containts 9 character string & 2nd cell contain 6 character numerical data. (note: we should able to extract sepecial charecters as well.)
AXIS-IT&T 532395


---Vishy

Extracting Text between 2 special characters of URL using Excel
 

Hi Vishy,

Am Mon, 5 Mar 2012 05:21:38 -0800 (PST) schrieb :

Thanks a lot Claus Busch.. it is working but extracted data is like below in single cell.
AXIS-IT T 532395 (Note: & is missed between T&T.)

try:
=SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Extracting Text between 2 special characters of URL using Excel
 

Hi,

Am Mon, 5 Mar 2012 14:47:05 +0100 schrieb Claus Busch:

=SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ")

and then Data = Text to Columns and space as seperator


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Extracting Text between 2 special characters of URL using Excel
 

Working....Thanks a lot Claus Busch.

Extracting Text between 2 special characters of URL using Excel
 

On Monday, March 5, 2012 8:35:30 PM UTC+5:30, wrote:
Working....Thanks a lot Claus Busch.

Hi Claus Busch

plz check another post of mine ie "How should i call below function" in this forum.

i want to download multiple no of zip files from internet based on range of dates.so i found one function ie URLDownloadToFile() while googling & i tried the same @ my end,but no progress on it.

kindly check that post & let me know how should i use that function.

Thanks in Adv.

Regards
Vishy