This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Okay so it looks like the trimright([field],"-301") function was looking for any of the characters in -301 at the end of the string and replacing them with nothing; I thought it would do the entire string only.
Anyway, the second solution I have provided should be adequate!