4 Replies Latest reply on Oct 17, 2013 6:35 AM by philmodjunk

    concatenation -

    jeanamick

      Title

      concatenation -

      Post

           Hello,

           If(IsEmpty(Nickname);Member First &" "&Member Last; Nickname &" " &Member Last)

            

           THIS WORKED>>>>thanks!

        • 1. Re: concatenation -
          schamblee

               If the nick name is going to be added to the end then First Name &" "& Last Name &" "&NickName

               Or you could use an if statement if you are adding the nickname to the beginning of the calculation

               If(IsEmpty(Nickname);First Name &" "&Last Name; Nickname &" "& First Name &" " &Last Name)

          • 2. Re: concatenation -
            philmodjunk

                 You could also use:

                 Substitute ( List ( NickName ; FirstName ; LastName ) ; ¶ ; " " )

            • 3. Re: concatenation -
              jeanamick

                   Thank you so much... The basic first name last name concatenation worked great with your input.

                    

                   I tried this If(IsEmpty(Nickname);Member First &" "&Member Last; Nickname &" "& Member First &" " &Member Last)  

                    

                   but what happened worked sort of -

                   got the Suzy Susan Smith    -  but Susan popped up in the middle...only want Nickname if there is one, then Last Name.  Help again please.  

                    

                    

              • 4. Re: concatenation -
                philmodjunk

                     If(IsEmpty(Nickname);Member First &" "& Member Last; Nickname  &" " & Member Last)