Outputting to text file

[ljg]

I have a single-column query that I need to output to a text file in a list format. I used the TransferText macro and I get the list I want but each line item is surrounded by quotes:
"item1"
"item2"
"item3"

I need to see data like this:
item1
item2
item3

Is there a way to format this or am I forced to manually do a "replace" in Notepad before I can process the list?

Thanks in advance,
LJG

 

[PHV]

did you use a SpecificationName ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ljg]

It says I need to choose the specification name from the drop-down list, but there is nothing in the list. I am exporting delimited.

 

[ljg]

AH-HA I got it - thanks for the tip PHV!! I read a little into the help files and found the info I needed. I created the Specification file and it runs like a charm!!!

 

[jebry]

Hi!

Select the query and go to File - Export. When the Export Window comes up choose text in the file type and click the Export button. This will start the export text wizard. If you click the advanced button, one of options you will get is text delimiter. Change this to none and procede with your import. This is where you can store the specification also.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst