How to Extract from a long string

[ginkoba]

Please help. new to the forum.

Here is what I am trying to accomplish. I am trying to extract just this part from the below listed data in a descriptive field "08_December". Just the number and the name of the month. Is there a formula or code that I can use to do this and then group by that formula?

"

http://mrbasrv.na.aarp.int:80/PatchManagement/PatchGroups/08_December"

 

[lbass]

Try:

stringvar array x := split({table.string},"/");
x[ubound(x)]

-LB

 

[ginkoba]

Thanks LB. I do get an error:

"A subscript must be between 1 and the size of the array

 

[lbass]

That's odd. Try this:

stringvar array x := split({table.string},"/");
if ubound(x) >= 1 then
x[ubound(x)] else
{table.string}

-LB

 

[ginkoba]

Thanks a million LB. Worked perfectly!