Any saved search expert can help with a formula pls? I have a document number on bill payment as 08000/1 ( due to EFT payment) in my saved search I only want to bring 08000 as document number. Any help with function or formula is appreciated.

http://www.netsuiterp.com/2018/11/using-replace-and-substr-for-formula.html I use SUBSTR all the time for stuff like this, but you can probably simplify things with REPLACE in this instance.

Thanks Mike this was very helpful.