This content has been marked as final. Show 7 replies
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!