I have a DTS job that creates a .txt file out of an Access table. The Access table has a number of carriage returns that need to be stripped before the .txt file can be used correctly. Instead of stripping the Access table fields, I am looking to find a way to automate the replacement of these carriage returns on the .txt file. I have seen a bunch of dos to unix instructions out there, but I don't have (or know) unix and I want to automate this on a WINXP or WIN2000 server machine.
Is there a way to automate the stripping of carriage returns in a .txt file, say from teh command prompt & a batch file, or when running the DTS job that creates the .txt file?