Post reply

Eliminate carriage return in data

  • June 27, 2007 at 6:12 pm

    #715672

    Joe, as far as it's described it's not your problem.

    The file you've got is built not according to tab-delimited text file specification.

    The thing is building those files is faulty and must be fixed.

    Trying to fix somebody's else file on-fly you're putting yourself in danger of being blamed for data corruption or data loss in case if you modification one day will get anything wrong.

    Find a spec for tab-delimited text file and let them do their job.

    _____________
    Code for TallyGenerator

  • June 28, 2007 at 7:42 am

    #715851

    Good Points.  We went through something similar a while back, trying to import Excel files with garbage in them. At first we tried fixing it in SQL, but then said "Give us better data, and clean it up before giving it to us"

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply