JSL Companion

2

Reading and Saving Data

Introduction

Read Data into Data Tables

Set Column Formats

Create Data Tables

Close and Save Data Tables

Retrieve Data from a Database

Read Multiple Files in a Directory

Parse Messy Text Files

Parse XML Files

Introduction

Discovering the stories hidden in your data begins with getting the data. Fortunately, JSL provides multiple methods to read data from many different sources. Common data sources include:

• databases and files created by database query tools
• JMP, SAS, Excel, and simple text files often in .csv or .txt formats
• files generated by equipment or measurement tools

The last source can be simple text files, but some are not so simple. For example, files written in XML format are widespread, and parsing them ...