Split Issue

[Extrmdressage]

I need to split data like this

40/52
39.5/52
37.5/49

into just the first portion of data before the /. I tried using a split function, but get an error saying the result of a formula cannot be an array. Does anyone have any ideas on how I can get around this?

 

[briangriffin]

You just need to subscript the formula you already have:

split({yourfield},"/")[1]

 

[fisheromacse]

if you always want everything to the left of the first "/", this should do it.

left({table.field},(instr({table.field},"/")-1)

 

[Extrmdressage]

Thank you very much