Discussions
Categories
Groups
Help
Home
User Community
Discussions
Text File save No labels
clark_woo-seag_
I want to save text file with no Label
but I can't find option for no label
dt=open("d:\aa.txt", End of Field(comma), Labels(0),
columns( aa=character(100) ));
dt<
Please let me know how to use save option.
Accepted answers
All comments
unknown
I thought this was going to be an easy one, but it seems to be a little more involved than I'd expected. What you need to know is what all the options are for the save command - and my manual isn't very informative on that, so what I'd normally do next is to run the command interactively and inspect the code that's been automatically generated as a result. However although I can load data
from
a text file and look at the resulting script associated with the resulting data table (it's shown below) to show a list of the various choices I can make, I can't find a way to do the same when exporting data
to
a text file. So how
do
I find out what all the options are for the save command? Anyone?
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Open
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"d:\aa.txt"
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
columns
(
a
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Numeric
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
b
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Character
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
c
style="font-size: 9pt; font-family: "Courier New"; color: navy;">=
style="font-size: 9pt; font-family: "Courier New"; color: black;">
Numeric
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Import
Settings
(
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
End
Of Line
(
CRLF
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
CR
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
LF
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
End
Of Field
(
Comma
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Strip
Quotes
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Use
Apostrophe as Quotation Mark
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Scan
Whole File
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Labels
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">0
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Column
Names Start
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Data
Starts
(
style="font-size: 9pt; font-family: "Courier New"; color: teal;">1
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Lines
To Read
(
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">All
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">,
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
Year
Rule
(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"10-90"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="">
)
style="font-size: 9pt; font-family: "Courier New"; color: black;">)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
style="font-size: 9pt; font-family: "Courier New"; color: navy;"><<
style="font-size: 9pt; font-family: "Courier New"; color: black;">
save
(
style="font-size: 9pt; font-family: "Courier New"; color: purple;">"d:\aa2.txt"
style="font-size: 9pt; font-family: "Courier New"; color: black;">
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: rgb(0, 0, 221);">show
properties
style="font-size: 9pt; font-family: "Courier New"; color: black;">(
style="font-size: 9pt; font-family: "Courier New"; color: black;">dt
)
style="font-size: 9pt; font-family: "Courier New"; color: navy;">;
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
style="font-size: 9pt; font-family: "Courier New"; color: black;">
ms
In the menu Preferences/Text Data Files you can you can change the export settings. There is check box for including labels, make sure it is not checked. This of course affects all files.
unknown
That'll solve the immediate problem, I'm sure - many thanks! To do that in code, the necessary option can be found by running "show preferences(all)" and looking in the "Export Settings" section.
The following should therefore answer the original question about how to export without labels - the first export leaves them out, whereas the second one includes them:
dt = open("$SAMPLE_DATA/Big Class.jmp");
Preference(Export Settings(Export Table Headers(0)));
dt << save("C:\File0.txt", text);
Preference(Export Settings(Export Table Headers(1)));
dt << save("C:\File1.txt", text);
Message was edited by: David Q/R
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
