Help with the instr, mid functions please

[AnnetteB1305]

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

 

[briangriffin]

If the field is always populated with the first three elements, and you're always looking for the third one, then this is all you need:

split({HardwareType}," -> ")[3]

If that's not the case, then a different approach is needed - please supply more sample data.

 

[AnnetteB1305]

No that's great why didn't I think of split however I am getting an error message a subscript must be between 1 and the size of the array

 

[AnnetteB1305]

Just checked and they don't always have 3 elements however I only want to show the fields that do have 3 elements

 

[briangriffin]

if ubound(split({HardwareType}," -> ")) >= 3

then

split({HardwareType}," -> ")[3]

else

"Whatever you want to display"

 

[crystalkiwibruce]

You could modify Brians suggestion as follows...

Local stringvar array ProdTypes := split({HardwareType}," -> ");
if count(ProdTypes)>= 3 then ProdTypes [3] else ""

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[AnnetteB1305]

Thank you very much, this has been a great help