The transforms in this category convert the input value to an output value by using the input value as a key to find the output value in a lookup table.
| Transform | Description |
|---|---|
| abbr | Converts the input value to an abbreviation using a lookup table |
| abbrSplit | Splits the input field into substrings and searches for a substring it can convert to an abbreviation using a lookup table |
| full | Converts the input value from an abbreviation a full value using a lookup table |
| fullSplit | Splits the input field into substrings and searches for a substring it can convert from an abbreviation to a full using a lookup table |
| lookup | Converts the input value from its initial value to a replacement value using a lookup table |
| lookupSplit | Splits the input field into substrings and searches for a substring it can convert from its initial value to a replacement value using a lookup table |
Table Contents
The contents of the tables available in ORA are maintained on GitHub. You may review them and suggest changes via this page: https://github.com/jfcardinal/ORA-Tables
abbr:tableName
Converts the input value to an abbreviation using a specified lookup table.
For example, if a field named State has the value "Rhode Island", the result of [State:abbr:us_states] is "RI".
If the input value is not found on the lookup table, the abbr transform returns an empty value. If you want to insert the field's value when no abbreviation is found, you can use a conditional expression where the abbreviation is inserted, or if there is no abbreviation, the original value is inserted:
<[State:abbr:us_states]|[State]>Table Names
| Name | Description |
|---|---|
| au_states | Australian States and Territories |
| ca_provinces | Canadian Provinces and Territories |
| chapman | Chapman codes for the Channel Islands, England, Northern Ireland, Scotland, and Wales |
| it_provinces | Italian Provinces |
| it_regions | Italian Regions |
| place | A combination of the au_states, ca_provinces, and us_states tables |
| us_states | US States |
The contents of the tables listed above are maintained on GitHub. You may review them and suggest changes via this page: https://github.com/jfcardinal/ORA-Tables
abbrSplit:tableName:separator
Splits the input field into substrings and searches for a substring it can convert to an abbreviation. Supports several lookup tables as listed above under abbr transform. It searches from the end of the value.
This transform is a special combination of the abbr and split transforms. It is mostly intended for use with location fields that may contain several subdivisions. abbrSplit will lookup each part, from last to first, until it finds a part that matches a key in the given table. So, for example, to convert "Boston, Massachusetts, USA" to "MA":
<[Place:abbrSplit:us_states:,]>The process is as follows:
- Split the field into parts, "Boston", "Massachusetts", "USA".
- Search for "USA" in the "us_states" table. No match.
- Search for "Massachusetts" in the "us_states" table. There is a match and the abbreviation is "MA". Return "MA".
lookup:tableName
Changes the input value from its initial value to a replacement value found in the given table. Supports the table(s) listed below.
For example, if a field named Source.Year has the value "1940", the result of [Source.Year:lookup:us_federal_year_to_nara_series] is "T627".
If the specified table returns a date value, the value is formatted according to the user's Date Format preference.
Table Names
| Name | Description |
|---|---|
| ca_census_year_to_date | Converts a Canadian Census Year to the official date of that census. For example, it will convert "1871" to "2 APR 1871".
You can convert the result to a different date format by chaining the date transform to the result. |
| se_region_name | Converts Swedish regional archive codes to regional archive names. For example, it will convert "OLA" to "landsarkivet i Östersund".
|
| se_region_location | Converts Swedish regional archive codes to regional archive locations. For example, it will convert "OLA" to "Östersund".
|
| uk_census_year_to_date | Converts a UK Census Year to the official date of that census. For example, it will convert "1841" to "6 JUN 1841".
You can convert the result to a different date format by chaining the date transform to the result. |
| us_census_year_to_date | Converts a US Federal Census Year to the official date of that census. For example, it will convert "1800" to "4 AUG 1800".
You can convert the result to a different date format by chaining the date transform to the result. |
| us_federal_year_to_nara_series | Converts a US Federal Census Year to a NARA Series Number. For example, it will convert "1940" to "T627".
|
The contents of the tables listed above are maintained on GitHub. You may review them and suggest changes via this page: https://github.com/jfcardinal/ORA-Tables
lookupSplit:tableName:separator
Splits the input field into substrings and searches for a substring it can convert to a replacement value. Supports several lookup tables as listed above under the lookup transform. It searches from the end of the value.
This transform is a special combination of the lookup and split transforms. lookupSplit will lookup each part, from last to first, until it finds a part that matches a key in the given table.
For example, if a field named Source.Census has the value "1940 Census", the result of [Source.Year:lookupSplit:us_federal_year_to_nara_series: ] is "T627".
The process is as follows:
- Split the field into parts spearated by the space character. The result is "1940", "Census".
- Search for "Census" in the "us_federal_year_to_nara_series" table. No match.
- Search for "1940" in the "us_federal_year_to_nara_series" table. There is a match and the replacement value is "T627". Return "T627".
full:tableName
Changes the input value from an abbreviation to the full value. Supports several lookup tables.
For example, if a field named State has the value "RI", the result of [State:full:us_states] is "Rhode Island".
fullSplit:tableName:separator
Splits the input field into substrings and searches for a substring it can convert from an abbreviation to a full value. Supports several lookup tables as listed above under the abbr transform. It searches from the end of the value.
This transform is a special combination of the full and split transforms. It is mostly intended for use with location fields that may contain several subdivisions. fullSplit will lookup each part, from last to first, until it finds a part that matches a key in the given table. So, for example, to convert "Boston, MA, USA" to "Massachusetts":
<[Place:fullSplit:us_states:,]>The process is as follows:
- Split the field into parts, "Boston", "MA", "USA".
- Search for "USA" in the "us_states" table. No match.
- Search for "MA" in the "us_states" table. There is a match and the full value is "Massachusetts". Return "Massachusetts".