Types of Data

Work with Numbers, Strings, Dates, Currency, and More

This chapter discusses basic JSL data types:

• numbers and strings

• paths, which are a special type of string

• dates and times, which can be either special numbers or special strings

• currency

• hexadecimal values and blobs

At the end of the chapter are two sections that show more advanced methods of interacting with strings and pattern matching with regular expressions.

Contents

Numbers and Strings

Format Numbers

Unicode Characters

Path Variables

Create and Customize Path Variables

Relative Paths in Variables

File Path Separators

Date-Time Functions and Formats

Date-Time Values

Program with Date-Time Functions

Change Date-Time Values in Data Tables

Custom Date-Time Formatting with Format Patterns

Format Currency

Hexadecimal and BLOB Functions

Work with Character Functions

Concat Function

Munger Function

Repeat Function

Substitute and Substitute Into Functions

Regular Expressions

Regex Function

Regex Match Function

Special Characters in Regular Expressions

Escaped Characters in Regular Expressions

Greedy and Reluctant Regular Expressions

Backreferences and Capturing Groups

Lookaround Assertions

Pattern Matching

Parse Strings in Fixed Fields

Patterns and Case Matching

Troubleshoot Patterns

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).