Exporting Street Address with 2 lines error

[Guest]

When I do an export of user information from AD, and include the street address, some addresses with a 2nd line in the street, such as

132 West 31st Street
10 Floor

Have the rest of the information in the record shifted to the next line when exported to Excel.

[cmccullough]

Re: Exporting Street Address with 2 lines error

That is caused by having a CR/LF in the data. We added an advanced setting to replace CR/LF in AD data with your own string to avoid this problem. It is located under Tools->Settings->Advanced and is called AdCrLfReplacementString. For example you can enter | and it will replace CR/LF with the | character and keep from wrapping in Excel.

[Guest]

Re: Exporting Street Address with 2 lines error

Thanks for a quick reply. I wasn't sure I was describing the issue properly.

Ken Reid