Need to remove New Line character from a UDF Comment field
We have a UDF Comment field that sometimes has New Line character in it. When this occurs it throws off our CSV file formatting as it results in a new line on the file.
Can someone please tell me how to remove the new line character from the UDF projection? I tried to use Replace fucntion but not sure how to specify 'New Line' in the 2nd parameter.