AnnetteB1305
Technical User
I have a field hardware type which I need to only display the second section of the field. i.e an example of the field is:-
English -> Hardware -> Computer (Handheld) -> Fan and I just want to display Hardware. I am trying to use the instr and mid functions but I can't get this to work without doing three different formulae to get what I require.
Thanks in advance
Annette
English -> Hardware -> Computer (Handheld) -> Fan and I just want to display Hardware. I am trying to use the instr and mid functions but I can't get this to work without doing three different formulae to get what I require.
Thanks in advance
Annette