Announcement

Collapse
No announcement yet.

Exporting Street Address with 2 lines error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Exporting Street Address with 2 lines error

    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.

  • #2
    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.

    Comment


    • #3
      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

      Comment

      Working...
      X