Formating Names in VBScript

Results 1 to 3 of 3

Thread: Formating Names in VBScript

  1. #1
    Join Date
    Dec 1969

    Default Formating Names in VBScript

    I am using VBscript to pull from an AS400 database, where all of the data displays in uppercase letters. I am displaying Customer name and it displays as DOE, JOHN F. I am looking for a way to format the name so that the first letter of each name is Capital and the other letters are lowercase. The only tool I can find is Lcase but that converts them all to lowercase, I need the name to display as Doe, John F.

  2. #2
    Join Date
    Dec 1969

    Default RE: Formating Names in VBScript

    You can use the UCase () function, InStr()(nested) to find the first letter of the name , while using one of the other string functions to set the other letters to lowercase. That may be sort of awkward but just trying to help, hope it does.

  3. #3
    Ryan S. Guest

    Default RE: Formating Names in VBScript

    AS the INSTR() function only returns an integer noting the position in the string that your seach found its results at, this isn&#039t very helpful.<BR><BR>Does your AS400 field for Name contain the full name? Or do you have fields such as FirstName, LastName, MiddleInit, etc.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts