Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    83

    Unanswered: need help in string functions

    I have got a concatenated name as 'lastname, firstname' in a field called as 'Name'. I need to separate the last name and the firstname into two different fields.

    The lastname I was able to get it by using the following formulae
    Left([Name],(Instr([Name],',')-cstr(1)))

    But, having trouble to get the firstname right. Can anyone please help.
    Thanks in advance.

  2. #2
    Join Date
    Sep 2003
    Posts
    83
    I got it, by using the following formulae for the firstname

    right(Name,(len(Name) - (Instr([Name],', ')+cstr(1))))

    Thanks.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You might also try looking at the Split function ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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