I currently have two different orders and for this instance we will call it Order 123 and there is another order in the system with Order No 123. (with a full stop at the end). However, when I look in QlikView it is showing that there are two orders for 123 when in fact there aren't due to the full stop. Is there a way of getting around this?
I've just tried using Piet Hein van der Stigchel's and it hasn't worked.It is still bringing back the result as one, when it should be two. These are separate orders as well, so the PurgeChar function wouldn't work here (anbu cheliyan swuehl and ramko496)