Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    San Jose,Ca.
    Posts
    4

    Post Unanswered: Changing order of words in a field

    I have Data from A DB that comes formatted in the following manner:


    Name Field: DOWNING, Rodolfo & Maria

    I need this data in the following format:

    Rodolfo & Maria Downing

    Can anyone advise:???????

  2. #2
    Join Date
    Sep 2003
    Posts
    26

    RightWords

    Write a calculation field that does (assuming all are in that format)

    LeftWords(field,1) & LeftWords(field, 3).

    Hope that helps.

    www.fmdeveloper.com

Posting Permissions

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