Removing carriage returns and line feeds characters from a flat fi

#1

I'm getting a flat text file that I using in DTS. The files are fixed width
but occasionally rows will have misplaced carraige return line feeds <cr><lf>
embedded in them.

I planing on using FileSystemObject to exam the rows and then
Replace(sReadLine, chr(10) chr(13), chr(40)chr(40),,0)
Any body have this problem.

#2

LP,

if its a FIXED width file you should not have this problem at a cetain
point it should cut off and thats it. Is this a unix file? that might be a
problem.

"LP" wrote:

Quote:

I'm getting a flat text file that I using in DTS. The files are fixed width
but occasionally rows will have misplaced carraige return line feeds <cr><lf
embedded in them.

I planing on using FileSystemObject to exam the rows and then
Replace(sReadLine, chr(10) chr(13), chr(40)chr(40),,0)
Any body have this problem.

#3

Thanks for getting back with me.

I mispoke, I actually have both flat files and .csv. This one is a comma
seperated file.

Thanks for the tip.

LP

"Michael Evanchik" wrote:

Quote:

LP,

if its a FIXED width file you should not have this problem at a cetain
point it should cut off and thats it. Is this a unix file? that might be a
problem.

"LP" wrote:

I'm getting a flat text file that I using in DTS. The files are fixed width
but occasionally rows will have misplaced carraige return line feeds <cr><lf
embedded in them.

I planing on using FileSystemObject to exam the rows and then
Replace(sReadLine, chr(10) chr(13), chr(40)chr(40),,0)
Any body have this problem.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Removing carriage returns and line feeds characters from a flat fi

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Removing carriage returns and line feeds characters from a flat fi - 05-10-2005 , 06:40 PM

RE: Removing carriage returns and line feeds characters from a flat fi - 05-11-2005 , 07:48 PM

RE: Removing carriage returns and line feeds characters from a fla - 05-12-2005 , 07:40 AM