Welcome to Forums Sign in | Join | Help | Forums
in Search


Numeric string to text and remove punctuation

Last post 07-03-2008 9:50 AM by Sasha Lewis. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-02-2008 4:58 PM

    • Sasha Lewis
    • Not Ranked
    • Posts 9
    • Organization: Teach For America, Inc.
    • Products:  Blackbaud NetCommunity, The Financial Edge, The Raiser's Edge

    Numeric string to text and remove punctuation

    I am writing a CR report to take data and create a properly formatted import file.The constituent ID is a numeric string. It displays as 1,111,111.00. I need it to be a 1111111. Any ideas? I can convert it to a text field but cannot figure out how to remove the punctuation and .00.

     Thanks

    Sasha Lewis
    Database Development Manager
    PKD Foundation
    sashal@pkdcure.org
  • 07-03-2008 9:50 AM In reply to

    • Sasha Lewis
    • Not Ranked
    • Posts 9
    • Organization: Teach For America, Inc.
    • Products:  Blackbaud NetCommunity, The Financial Edge, The Raiser's Edge

    Re: Numeric string to text and remove punctuation

    I figured it out. I was making it harder than it needed to be. I needed to put the field in the report and change the formatting...Oh well, it was late when I was working on it. Big Smile

    Thanks!

    Sasha Lewis
    Database Development Manager
    PKD Foundation
    sashal@pkdcure.org
Page 1 of 1 (2 items)