split up string between every "/" in url 1

[kernal]

I'm using crystal 9 with a txt file. I have a field that contains urls and I need to extract the string between every "/" (not counting the "//" after "http:" or "https:"). Some urls might have one "/", some might have two "/" etc. so for something like:

http://www.cnn.com/2010/LIVING/07/27

I would want

http://www.cnn.com

2010
LIVING
07
27

Help is very appreciated.

 

[IdoMillet]

Split({your_column},"/")[3]

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kernal]

I'm getting an error "a subscript must be between 1 and the size of the array" when I try to search for [6]. I found the following and so I added the ubound function with the split part and it seems to be holding up. Thanks

if ubound(split({column},'/')) > 5 then
split({column},'/')[6]

 

[IdoMillet]

Good modification. Thanks for closing the loop.

Cheers,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com