[yoswalt]

Hey Rob, I called the blackbaud customer support line and found out that "/n" is for Raiser's Edge import. For Researcher's Edge, you can manually insert a paragraph mark in a text editor like notepad, wordpad, etc. by holding Alt key, then type 20 from the number key pad from the right side of the keyboard, the symbol will show up after you release the Alt key.

I thought I could find out the ascii equivalent and then generate it using sql. But unfortunately I found out that paragraph mark is a graphic symbol in IBM PC Extended Character Set (ECS). It also says 'Unfortunately, this ANSI character set is incompatible with the ECS character set used by DOS.' I created a case on the blackbaud support website and waiting for their response. I hope they can make TRE works the same way as Raiser's Edge. Otherwise, I need to use some odd character as a placeholder when using sql to generate the csv file, then need to ask my user to replace it with alt20 before they do the import.....which is the last solution I want to use.

Thanks for your help. I will let you and everyone know when I find out more.