Text identifiers in download file

[Tom Brown]

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Frank]

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Tom Brown]

Frank, I agree, but we noticed that when a memo field has embedded (&#34, ASDB does not double these. Therefore, when a proper name for example has quotes around it ("Brown&#34 the lead quote disapears. I remeber that when you have embedded quotes that you must add another.

Example:

Before: This word "Brown" is an example.
After: "This word ""Brown"" is an example."

The before ended up like this after importing into excel:
This word Brown" is an example.

Are we doing something wrong or not?


------------
Frank at 4/20/00 10:56:01 PM

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Mark]

Tom,
I see the problem. I will report it. In my opinion, ASP-db should replace all quotes with double quotes before writing to the csv file, so that:

"Lou "The Toe" Groza"
becomes
"Lou ""The Toe"" Groza"

Then it will import into Excel properly.

Mark.


------------
Tom Brown at 4/21/00 2:20:13 PM

Frank, I agree, but we noticed that when a memo field has embedded (&#34, ASDB does not double these. Therefore, when a proper name for example has quotes around it ("Brown&#34 the lead quote disapears. I remeber that when you have embedded quotes that you must add another.

Example:

Before: This word "Brown" is an example.
After: "This word ""Brown"" is an example."

The before ended up like this after importing into excel:
This word Brown" is an example.

Are we doing something wrong or not?


------------
Frank at 4/20/00 10:56:01 PM

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Frank]

Tom,
Maybe I misunderstood your problem. Can you show a sample of csv file that can fill the cell with the text enclosed with double quotes like -> "Text of Cell"

FK



------------
Tom Brown at 4/21/00 2:20:13 PM

Frank, I agree, but we noticed that when a memo field has embedded (&#34, ASDB does not double these. Therefore, when a proper name for example has quotes around it ("Brown&#34 the lead quote disapears. I remeber that when you have embedded quotes that you must add another.

Example:

Before: This word "Brown" is an example.
After: "This word ""Brown"" is an example."

The before ended up like this after importing into excel:
This word Brown" is an example.

Are we doing something wrong or not?


------------
Frank at 4/20/00 10:56:01 PM

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Tom]

I wasn't that clear. Check out Mark's response on the 21st.


------------
Frank at 4/21/00 11:49:03 PM

Tom,
Maybe I misunderstood your problem. Can you show a sample of csv file that can fill the cell with the text enclosed with double quotes like -> "Text of Cell"

FK



------------
Tom Brown at 4/21/00 2:20:13 PM

Frank, I agree, but we noticed that when a memo field has embedded (&#34, ASDB does not double these. Therefore, when a proper name for example has quotes around it ("Brown&#34 the lead quote disapears. I remeber that when you have embedded quotes that you must add another.

Example:

Before: This word "Brown" is an example.
After: "This word ""Brown"" is an example."

The before ended up like this after importing into excel:
This word Brown" is an example.

Are we doing something wrong or not?


------------
Frank at 4/20/00 10:56:01 PM

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"

[Frank]

Ok,

Mark, can you psot a sample .CSV file that would provide the correct loading of the cells like ->

1 2 3 "4"
5 6 7 "8"

Frank


------------
Tom at 4/22/00 12:49:23 PM

I wasn't that clear. Check out Mark's response on the 21st.


------------
Frank at 4/21/00 11:49:03 PM

Tom,
Maybe I misunderstood your problem. Can you show a sample of csv file that can fill the cell with the text enclosed with double quotes like -> "Text of Cell"

FK



------------
Tom Brown at 4/21/00 2:20:13 PM

Frank, I agree, but we noticed that when a memo field has embedded (&#34, ASDB does not double these. Therefore, when a proper name for example has quotes around it ("Brown&#34 the lead quote disapears. I remeber that when you have embedded quotes that you must add another.

Example:

Before: This word "Brown" is an example.
After: "This word ""Brown"" is an example."

The before ended up like this after importing into excel:
This word Brown" is an example.

Are we doing something wrong or not?


------------
Frank at 4/20/00 10:56:01 PM

what is a good reason for that? If it is removed then it would not be a csv file and the fields might not load into Excel correctly.

FK



------------
Tom Brown at 4/20/00 12:03:06 PM

How can I remove the text identifiers (&#34 in the download file.

Example: 1,23456,"text field","7045-2345"