Export table (or query) to .csv w/o " or .

  • Thread starter Thread starter tsar IV
  • Start date Start date
T

tsar IV

I'm trying to use TransferText to export either a table or query to a .csv
file. The results should look like -
abcdef,DIR,K,49,25,1279

but I only seem to be able to get either of the following -
"abcdef","DIR","K","49","25","1279"
or
abcdef,DIR,K,49.,25.,1279.

Is there any way to remove the decimal point from the latter or the quote
marks from the former? I've tried tinkering with the format of the query,
the specifications (leading to the results I get), and a few other things.
Am I missing something?
 
Not sure but you might try ensuring that the values showing up with
decimal points are text fields, not numeric fields.

If you don't want to change the table's field format, maybe try using:
Cstr([Fieldname])
for your query columns instead of just selecting the field by itself.
 
Thanks, after a tweak to the SpecificationName, this worked like a charm!
Thanks again!

Michael J. Strickland said:
Not sure but you might try ensuring that the values showing up with
decimal points are text fields, not numeric fields.

If you don't want to change the table's field format, maybe try using:
Cstr([Fieldname])
for your query columns instead of just selecting the field by itself.


--
Mike

-----------------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
-----------------------------------------------------------------------
tsar IV said:
I'm trying to use TransferText to export either a table or query to a
.csv
file. The results should look like -
abcdef,DIR,K,49,25,1279

but I only seem to be able to get either of the following -
"abcdef","DIR","K","49","25","1279"
or
abcdef,DIR,K,49.,25.,1279.

Is there any way to remove the decimal point from the latter or the
quote
marks from the former? I've tried tinkering with the format of the
query,
the specifications (leading to the results I get), and a few other
things.
Am I missing something?
 
Back
Top