LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Removing Middle Names

    Employee
    Posted 07-10-2017 13:17

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Hello

    I have name records such as below;

    Wilbur, James Anthony

    How do I remove "Anthony" out of the name?

    Thanks


  • 2.  RE: Removing Middle Names

    Employee
    Posted 07-10-2017 13:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Try this:
    s=split(FullName,",")
Last=s[0]
First=s[1]

n=First.strFindI(" ")
if n>-1 then First=First.left(n)
NewName=Last + ", " + First


  • 3.  RE: Removing Middle Names

    Employee
    Posted 07-12-2017 08:17

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Hi Stony

    I am having an issue where it is taking off the last letter of first name on random records.

    I also had to add a trim before onto the n=trim(First)