Results 1 to 3 of 3

Thread: Text cleanup

  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm wondering if there is any help out there with the process of cleaning up legacy data as it heads into a new ERP. Specifically, description fields where we want to either parse out certain texts, or delete certain character combinations (lbs, for instance) or replace # with lbs, things like that. We've got tens of thousands of records to cleanse, so I'm wondering if there is any program or way of addressing these issues in large blocks. TYIA

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,571
    Thanks
    5
    Thanked 1,056 Times in 925 Posts
    [quote name='Torquemada' post='774369' date='08-May-2009 15:01']I'm wondering if there is any help out there with the process of cleaning up legacy data as it heads into a new ERP. Specifically, description fields where we want to either parse out certain texts, or delete certain character combinations (lbs, for instance) or replace # with lbs, things like that. We've got tens of thousands of records to cleanse, so I'm wondering if there is any program or way of addressing these issues in large blocks. TYIA[/quote]

    1.) What is the target database?
    2.) Is there a budget?
    3.) How much code are you willing to write?

    Joe
    Joe

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    [quote name='Torquemada' post='774369' date='08-May-2009 13:01']I'm wondering if there is any help out there with the process of cleaning up legacy data as it heads into a new ERP.[/quote]
    Many consultants make a good living doing just that. The conversion costs for ERP projects typically exceed the software license costs!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •