Random line breaks in text output

[KevinLogue]

I am running a query in access 2007 and then running a saved export to
pipe-delimitted text file. I am getting what seem to be random line breaks in
the output text file. They are not truncated at any particular column length
and not all are split with line breaks.

Example
line one runs out to 527 chars clean
line two truncates at 256 and continues on next line.

Hidden characters in fields of DB?
Some other issue?

 

[Ken Snell [MVP]]

Soounds like the datea in the field contains carriage return and line feed
characters (so that you see separate lines of text in ACCESS). You'll need
to strip them out in your query:

SELECT Replace(FieldName, Chr(13) & Chr(10), " ") AS NewFieldName,
Field1, Field2, Field3
FROM Yourtablename;

 

[KevinLogue]

Thanks Ken,

I will give this a shot on monday. I appreciate the help.

Kevin