Sorry i stuffed up before i need only vmr 466 or VMR 466 to be changed to VMR466 in the From field, what was suggested before changes everything withe no spaces.
Upper( Substitute ( From ; [¶ ; ""] ;[" ";""] ) )
That's why I had "put expression you want here when Try1 is not VMR466". You can put any expression you want there to get the results needed when it's not a VMR466 entry.
Let (Try1 = Upper( Substitute ( From ; [¶ ; ""] ;[" ";""] ) ) ; case ( Try1 = "VMR466" ; Try1 ; Trim ( Upper( Substitute ( From ; ¶ ; "" ) ) ) ) )
Let (Try1 = Upper( Substitute ( From ; [¶ ; ""] ;[" ";""] ) ) ; case ( Try1 = "VMR466" ; Try1 ; "put expression you want here when Try1 is not VMR466" ) )
I'm not at all sure that's what you really had in mind here. If the possible input values are this limited, why not use a drop down list or pop up menu of values to eliminate the possbility of these input errors in the first place?
Is there any way to only change vmr 466 or VMR 466 to VMR466 but anythingthing else entered will have a space if needed, you see we get call from the WATER POLICC, VTS GLADSTONE, and our operators eg A CLARKE, its just the vmr 466 that is causing problems with the management
The reason i don't have a value list for the From field is that we have general public calling us all the time and the value list would be huge, we only have a couple of operators that enter vmr466 with a space so as it is the first choice in the auto fill list.
Hope that makes sense
Sorry man my head is not working this morning should go get some sleep and not post when nodding off.
Thanks for your help.
Retrieving data ...