7 Replies Latest reply: Jul 18, 2017 2:23 AM by Ruben Marin RSS

    Combing two functions in load script (trim and replace)

    Ryan Minaker

      Hi,

       

      I'm trying to clean up a field and need to apply two functions in the load script. I've read through several other discussion posts and just can't seem to get the right syntax for this to work.

       

      These are the two functions that I'd like to combine (both work as expected on their own). Any help is much appreciated.

       

      If(Len(Trim(Instructor_Name)) > 0, Instructor_Name, 'None Specified') as [Instructor name],     //Replaced blanks with text

      Replace (Instructor_Name,'  ',' ') as [Instructor name],    //Removes extra spaces between instructor names

       

      Thanks in advance!

       

      R.