Extracting Part of Name

[ij76]

I need to extract parts of some project names, but can't use Left(str, length) since the number of characters to extract are different. I would need it to do somehting like this:

if projectname =

http://www then

www
if projectname =

http://www/xxx,

do not include from / and on
if projectname = yyy then yyy
if projectname = yyy/zzzz, do not include from / and on

Any help would be much appreciated!

 

[kdk13]

If you know you will have a "/" or other character you can rely on, this should formula should work.

NumberVar endStr;
if InStr ({projectname},"/") <> 0 then
endStr := InStr ({projectname},"/") - 1
else
endStr := Length ({projectname});
Left ({projectname}, endStr )

 

[ij76]

Wow! That's awesome, it worked.

Thank you so much!!