Skip to Content
0
Dec 21, 2022 at 11:21 PM

Error: String length is less than 0 or not an integer

130 Views

I have an address field that reads "123 Address; grid-01; Business Name"

I want to only have the actual address of 123 Address.

I created the formula mid({lwmain.address},1,instr({lwmain.address},";")-1) which is providing the correct data, however there are a few address in there that only have "123 Address" with no ;. This is giving me the error of String length is less than 0 or not an integer.

I tried using the if isnot null formula and that isn't working because the field isn't actually null.

I keep trying different formulas, but I am stuck! Any help?

Thanks :)