Exporting Zip-codes as a string and not an integer

Options
Margaret Argyelan
Margaret Argyelan ✭
Tenth Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
I export my member information to a website on a regular basis and must do so as a CSV file.  The website, so as to integrate with a geolocation system (so folks can see where they are by zip code) needs to have the zip code as a string, not as an integer.  Is there a way I can change the zip code field so that it doesn't export as an integer?  thanks
Tagged:

Comments

  • Tomasz Malkiewicz 2
    Tomasz Malkiewicz 2 ✭
    Tenth Anniversary Facilitator 1 Photogenic

    Margaret Argyelan:

    I export my member information to a website on a regular basis and must do so as a CSV file.  The website, so as to integrate with a geolocation system (so folks can see where they are by zip code) needs to have the zip code as a string, not as an integer.  Is there a way I can change the zip code field so that it doesn't export as an integer?  thanks

    Hi Margaret,


    You can't do it in RE as the datatype of the field is determined in SQL. You can though convert the data in excel by using TEXT function.


    Tom

Categories