String manipulation

Results 1 to 2 of 2

Thread: String manipulation

  1. #1
    Join Date
    Dec 1969

    Default String manipulation

    I have a db field that conatins a full name like: roles, wallace<BR><BR>I need to seperate the first and last name and put them in their on field but there are thousands of records so does anyone know of way to seperate the first from the last?

  2. #2
    Join Date
    Dec 1969

    Default RE: Split will do the trick

    Dim str1, str2<BR> <BR> str1 = "Roy, Name"<BR> <BR> str2 = split(str1,",")<BR> Response.Write str2(0) & str2(1)<BR> <BR><BR>Remember split returns an array.

Posting Permissions

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