Does anyone know how to impliment proper case in Navision?
I have a csv import file of sales orders and some of the address fields are appearing in lower case. I would like to convert them to proper case as part of the import.
e.g. north cheshire
should be North Cheshire
I could do this in excel however a proper case function would be very useful in Navision.
thanks in advance
LLoyd
0
Comments
This will start every new word entered in the field with a capital letter.
So something like 'this is a test' will automatically change into 'This Is A Test'.
Here is function I've written a while back that does what you want.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n