I am using Microsoft Query to retrieve data from a csv file. The csv file contains a mixture of data types, some text and some values.

Some of the fields contain Carriage Returns or Line Feeds (CR/LF) not sure which? embedded in the fields displaying as square boxes i.e. "MBRB123A12345□"

When I create a query I seem to be getting a problem with query interpreting these CR/LF and the query not returning the data correctly (the character is being treated as a end of record mark and fields after the CR/LF are being ignored.

Does anyone know how to stop MS Query interpretting these CR/LF as end of record marks, if not, does anybody know how I can strip them out of the source file