Skip to Content
0
Former Member
Feb 26, 2009 at 11:27 PM

Searched for character not in data

19 Views

I'm using the formula below to find the slash ("/") in some data. It works well 97% of the time but some of the data doesn't have a slash and then the program crashes, saying "String Length is less than 0 or not an integer".

left ({TRACE.APROPERTY_2},InStr ({TRACE.APROPERTY_2},"/")-1)

Is there a way around this?