How do I grab the 2nd path item from an url? Regex?

[cdumper]

How can I parse the path of an url and grab the 2nd item in a path. Eg from http://www.bccdc.ca/dis-cond/a-z/_c/...ox/default.htm I need to grab 'a-z'. Can I somehow use a regular expression? Thx!!!

column A = http://www.bccdc.ca/dis-cond/a-z/_c/...ox/default.htm
column B = dis-cond (already have this column working)
column C = a-z (????)

[Ron Coderre]

With
A2: http://www.bccdc.ca/dis-cond/a-z/_c/...ox/default.htm

These regular formulas returns the 1st and 2nd subpaths

Please Login or Register  to view this content.

In that example, those formulas return:
dis-cond
a-z

Is that something you can work with?

[cdumper]

Absolutely. I'll give that a shot. MANY THANKS!