Remove First and Last String of Breadcrumbs Query Field

[fgwapo]

Hello,

Need help in removing the first and last string of breadcrumb.

Field1:

Home > Main Category > Sub1 > Sub2 > Item
Home > Main Category > Sub1 > Item

Output:

Main Category > Sub1 > Sub2
Main Category > Sub1


Any help is highly appreciated.

fgwapo

 

[arnelgp]

Left(Mid(Field1,Instr(Field1,">")+1), InstrRev(Mid(Field1,Instr(Field1,">")+1), ">")-1)

 

[fgwapo]

Hello,

Tried the code it says:

Error: The expression you entered has a function containing the wrong number of arguments.


Thanks

 

[arnelgp]

sorry about that, here try:

Left(Mid(Field1, InStr(1, Field1, ">") + 2), InStrRev(Mid(Field1, InStr(1, Field1, ">") + 2), ">") - 2)