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 :)