Configuring synthesis options
For some value types, when you select the Synthesis option, you can configure additional options for how Tonic Textual generates the replacement values.
To display the available options, click Options.
Configuring location synthesis options
Location values include the following types:
Location
Location Address
Location State
Location Zip
For each location types other than Location State, you can specify whether to use a realistic replacement value. For Location State, based on HIPAA guidelines, both the Synthesis option and the Off option pass through the value.
For location types that include zip codes, you can also specify how to generate the new zip code values.
Indicating whether to use realistic replacement values
By default, Textual replaces a location value with a realistic corresponding value. For example, "Main Street" might be replaced with "Fourth Avenue".
To instead scramble the values, uncheck Replace with realistic values.
Indicating how to generate replacement zip codes
By default, to generate a new zip code, Textual selects a real zip code that starts with the same three digits as the original zip code. For a low population area, Textual instead selects a random zip code from the United States.
To instead replace the last two digits of the zip code with zeros, uncheck Replace zeroes for zip codes. For a low population area, Textual instead replaces all of the digits in the zip code with zeros.
Configuring datetime synthesis options
By default, when you select the Synthesis option for Date/Time values, Textual shifts the datetime values to a value that occurrs within 7 days before or after the original value.
To customize how Textual sets the new values, you can:
Set a different range within which Textual sets the new values
Indicate whether to scramble date values that Textual cannot parse
Add additional date formats for Textual to recognize
Adjusting the range for the replacement values
By default, Textual adjusts the dates to values that are within 7 days before or after the original date.
To change the range, in the # of Days To Shift +/- field, enter the number of days before and the original date within which the replacement datetime value must occur. For example, if you enter 10, then the replacement datetime value must occur within 10 days before or after the original value.
Indicating how to replace datetime values in unsupported formats
Textual can parse datetime values that use either a format in Default supported datetime formats in Textual or a format that you add.
The Scramble Unrecognized Dates checkbox indicates how Textual should handle datetime values that it does not recognize.
By default, the checkbox is checked, and Textual scrambles those values.
To instead pass through the values without changing them, uncheck Scramble Unrecognized Dates.
Adding datetime formats
By default, Textual is able to recognize datetime values that use a format from Default supported datetime formats in Textual.
Under Additional Date Formats, you can add other datetime formats that you know are present in your data.
The formats must use a Noda Time LocalDateTime pattern.
To add a format, type the format in the field, then click +.
To remove a format, click its delete icon.
Default supported datetime formats in Textual
By default, Textual supports the following datetime formats.
Date only formats
| Format | Example value |
|---|---|
yyyy/M/d | 2024/1/17 |
yyyy-M-d | 2024-1-17 |
yyyyMMdd | 20240117 |
yyyy.M.d | 2024.1.17 |
yyyy, MMM d | 2024, Jan 17 |
yyyy-M | 2024-1 |
yyyy/M | 2024/1 |
d/M/yyyy | 17/1/2024 |
d-MMM-yyyy | 17-Jan-2024 |
dd-MMM-yy | 17-Jan-24 |
d-M-yyyy | 17-1-2024 |
d/MMM/yyyy | 17/Jan/2024 |
d MMMM yyyy | 17 January 2024 |
d MMM yyyy | 17 Jan 2024 |
d MMMM, yyyy | 17 January, 2024 |
ddd, d MMM yyyy | Wed, 17 Jan 2024 |
M/d/yyyy | 1/17/2024 |
M/d/yy | 1/17/24 |
M-d-yyyy | 1-17-2024 |
MMddyyyy | 01172024 |
MMMM d, yyyy | January 17, 2024 |
MMM d, ''yy | Jan 17, '24 |
MM-yyyy | 01-2024 |
MMMM, yyyy | January, 2024 |
Date and time formats
| Format | Example value |
|---|---|
yyyy-M-d HH:mm | 2024-1-17 15:45 |
d-M-yyyy HH:mm | 17-1-2024 15:45 |
MM-dd-yy HH:mm | 01-17-24 15:45 |
d/M/yy HH:mm:ss | 17/1/24 15:45:30 |
d/M/yyyy HH:mm:ss | 17/1/2024 15:45:30 |
yyyy/M/d HH:mm:ss | 2024/1/17 15:45:30 |
yyyy-M-dTHH:mm:ss | 2024-1-17T15:45:30 |
yyyy/M/dTHH:mm:ss | 2024/1/17T15:45:30 |
yyyy-M-d HH:mm:ss'Z' | 2024-1-17 15:45:30Z |
yyyy-M-d'T'HH:mm:ss'Z' | 2024-1-17T15:45:30Z |
yyyy-M-d HH:mm:ss.fffffff | 2024-1-17 15:45:30.1234567 |
yyyy-M-dd HH:mm:ss.FFFFFF | 2024-1-17 15:45:30.123456 |
yyyy-M-dTHH:mm:ss.fff | 2024-1-17T15:45:30.123 |
Time only formats
| Format | Example value |
|---|---|
HH:mm | 15:45 |
HH:mm:ss | 15:45:30 |
HHmmss | 154530 |
hh:mm:ss tt | 03:45:30 PM |
HH:mm:ss'Z' | 15:45:30Z |
Last updated
