Eliminate carriage return in data

  • 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

  • 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