Proper Case Function

lloydf · 2007-10-18

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

M._Eleveld · 2007-10-18

What you could do is change the Title property of the Address field to Yes.
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'.

ara3n · 2007-10-18

hello.

Here is function I've written a while back that does what you want.

MyFormat(Name : Text[100]) : Text[100]
For I := 1 to Strlen(name) do begin
  if I = 1 then
    EVALUATE(Name[I], UPPERCASE(FORMAT(Name[I])))
  else
    IF Name[I-1] = 32 THEN
       EVALUATE(Name[I] ,UPPERCASE(FORMAT(Name[I])))
    ELSE
       EVALUATE(Name[I] ,LOWERCASE(FORMAT(Name[I])));
end;
EXIT(Name);

Proper Case Function

Comments

Categories