Space in addresses

Abby Lau
Abby Lau
Name Dropper Kudos 1 Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

Anyone have a solution for random spaces in line 2 of the addresses? For some reason some of the addresses in our database have random spaces below the address and I am not sure how to run a query to find all of them and fix them. Has this happened to anyone?

Tagged:

Answers

  • Joe Moretti
    Joe Moretti Community All-Star
    Kudos 5 Third Anniversary Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply
    edited January 26

    In Database View, go to Plug-Ins and chose "Remove Blank Address Lines" and click begin. It may take a little time, but not that much, just depends.

    image.png

    image.png

    You also have another choice with a query set up like below. Do check the boxes of inactive, deceased or no valid address. Sometimes depending on how the record was put into the system you will have the first line blank and the 2nd line will have the address( Preferred address line 1 is blank). In your case where there are two lines, but the middle line has the blank, you have the criteria of Address line not Blank, address line 2 is blank, address line 3 not blank. But then when you get the results you need to fix them, where the Plug-In does all the work for you.

    image.png
  • Abby Lau
    Abby Lau
    Name Dropper Kudos 1 Facilitator 1

    Thanks Joe, this was very helpful and insightful! Do you know if this is a common bug where addresses will magically gain that space or is this usually a result of some issue during data entry?

  • Joe Moretti
    Joe Moretti Community All-Star
    Kudos 5 Third Anniversary Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply

    Some of it is from data entry, but I think a good bit is from an excel sheet that gets imported and there are spaces in the excel sheet. I run this as my regular database clean-up.

  • Abby Lau
    Abby Lau
    Name Dropper Kudos 1 Facilitator 1

    Thanks Joe! The plugin worked but trying your query I don't think it fully isolates and captures the issue. For example the issue I am having is that addresses are showing up like this, with a space between the address and city:

    Address Line 1

    City
    Province Postal Code

    Your query would show me both entries that look like that and regular entries that don't have line 2. Most of the time we don't use line 2 or 3. Would you be able to help me with figuring out a query that only shows me the addresses with issues?

  • Joe Moretti
    Joe Moretti Community All-Star
    Kudos 5 Third Anniversary Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply

    I think with the example you are showing, will not work, since the line that has a space is Address line 2. You are better off using the plugin, since it will deal with all various kind of issues, where there is a blank line.

  • Abby Lau
    Abby Lau
    Name Dropper Kudos 1 Facilitator 1

    Alright that's fine, for the most part it seems like the plugin does the job, just wanted to see if there is a way to regularly check for these errors. Thank you so much for your help Joe!

Categories