- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to use JSL to make TXT files of decimal data into binary format files?
Decimal files use recent tabs to divide data into three columns.
They are all integers:
The data in the first column ranges from 90,000 to 199,999
Column 2: positive integers from 100 to 900,000
Third column: positive and negative integers or 0
They have a lot of rows.
There is no limit to how to save them as binary files or file suffixes using JSL.
And need to figure out how to re-read restored decimal data from this new binary into JMP.
Thank you very much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to use JSL to make TXT files of decimal data into binary format files?
I still find this code.
I tried to write several did not work
Column(dt,1)<<Data Type(numeric(4))<<Set Modeling Type(Continuous);
Column(dt,1)<<Data Type(4)<<Set Modeling Type(Continuous);
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to use JSL to make TXT files of decimal data into binary format files?
- Chapters
- descriptions off, selected
- captions settings, opens captions settings dialog
- captions off, selected
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
End of dialog window.
This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to use JSL to make TXT files of decimal data into binary format files?
I see. I usually use JMP14 or 15.Because it's still Windows 7.
I tried another computer last night using JMP 16.I just saw it. "16.0.0"
Thanks for Craige's unreserved patient help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to use JSL to make TXT files of decimal data into binary format files?
The short numeric columns have been in JMP for a long time. Probably back to JMP 5, maybe longer. The preference menu has changed over time, but I think the script will work fine in old versions of JMP.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to use JSL to make TXT files of decimal data into binary format files?
OK
dt=Open("/C:/1/ss.txt",columns(
New Column("c000001",Numeric(4),"Continuous",Format("Best",12)),
New Column("c000002",Numeric(4),"Continuous",Format("Best",12)),
New Column("c000003",Numeric(4),"Continuous",Format("Best",12))),
Import Settings(End Of Line(CRLF,CR,LF),End Of Field(Tab,CSV(0)),Strip Quotes(1),
Use Apostrophe as Quotation Mark(0),Use Regional Settings(0),Scan Whole File(1),
Treat empty columns as numeric(0),CompressNumericColumns(0),CompressCharacterColumns(0),
CompressAllowListCheck(0),Labels(0),Column Names Start(1),Data Starts(1),Lines To Read("All"),
Year Rule("20xx")));
Thanks!
- « Previous
-
- 1
- 2
- Next »