Data export form table broken

[Sashi]

Hi All,

I have a table from which I want to export the data as a plain text
file.
I exported the data using the "Export" option and selected the comma
as a separator and the " as the Text Qualifier.

I have about 19800 records but a few hundred are broken over multiple
lines.
That is, the majority of records are exported correctly but some of
them are split up into more than one line?

For example this is a record: (selected via running a select from
query)

134S United States Of America 11695 "Woodland Hills - Oxnard
, 21550 Oxnard Street, Main Plaza" Woodland Hills California 91367
No No No No Site02720 Branch - Smith Barney & Private
Bank
When Access writes it out to a text file, the record is being split
after the first occurrence of the word "Oxnard" and I'm not sure why
this is happening.

Any suggestions?
Thanks,
Sashi

[Sashi]

On Jul 10, 2:37 pm, Sashi <[e-mail]:

Hi All,

I have a table from which I want to export the data as a plain text
file.
I exported the data using the "Export" option and selected the comma
as a separator and the " as the Text Qualifier.

I have about 19800 records but a few hundred are broken over multiple
lines.
That is, the majority of records are exported correctly but some of
them are split up into more than one line?

For example this is a record: (selected via running a select from
query)

134S United States Of America 11695 "Woodland Hills - Oxnard
, 21550 Oxnard Street, Main Plaza" Woodland Hills California 91367
No No No No Site02720 Branch - Smith Barney & Private
Bank
When Access writes it out to a text file, the record is being split
after the first occurrence of the word "Oxnard" and I'm not sure why
this is happening.

Any suggestions?
Thanks,
Sashi

All, I found the problem. I receive this data from another source and
it turns out that there are line breaks in the middle of a field.
To get rid of the line breaks, I'm running the following command:
UPDATE [tbl_CircuitData-Musto] SET FromLocation =
Replace(FromLocation,Chr$(13) & Chr$(10),'\n');
However, this still doesn't work.
Any help?
Thanks,
Sashi

[Bob Quintal]

Sashi <sm******@gmail.comwrote in
news:11*********************@r34g2000hsd.googlegro ups.com:

On Jul 10, 2:37 pm, Sashi <[e-mail]:

>Hi All,

I have a table from which I want to export the data as a
plain text file.
I exported the data using the "Export" option and selected
the comma as a separator and the " as the Text Qualifier.

I have about 19800 records but a few hundred are broken over
multiple lines.
That is, the majority of records are exported correctly but
some of them are split up into more than one line?

For example this is a record: (selected via running a select
from query)

134S United States Of America 11695
"Woodland Hills - Oxnard , 21550 Oxnard Street, Main Plaza"
Woodland Hills California 91367 No
No
No No Site02720
Branch - Smith Barney & Private Bank
When Access writes it out to a text file, the record is being
split after the first occurrence of the word "Oxnard" and I'm
not sure why this is happening.

Any suggestions?
Thanks,
Sashi

All, I found the problem. I receive this data from another
source and it turns out that there are line breaks in the
middle of a field. To get rid of the line breaks, I'm running
the following command: UPDATE [tbl_CircuitData-Musto] SET
FromLocation = Replace(FromLocation,Chr$(13) & Chr$(10),'\n');
However, this still doesn't work.
Any help?
Thanks,
Sashi

'\n' doesn't do much, just use " "

Some text files don't use chr(13) & chr(10), just one or the
other.try replacing chr(13) with " " and see if that helps

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com