advertisement

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:

  1. Split the field into parts, "Boston", "Massachusetts", "USA".
  2. Search for "USA" in the "us_states" table. No match.
  3. 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".
[Source.Year:lookup:ca_census_year_to_date]

You can convert the result to a different date format by chaining the date transform to the result.

[Source.Year:lookup:ca_census_year_to_date:date:Mmmm d, yyyy]
se_region_name Converts Swedish regional archive codes to regional archive names. For example, it will convert "OLA" to "landsarkivet i Ă–stersund".
[Code:lookup:se_region_name]
se_region_location Converts Swedish regional archive codes to regional archive locations. For example, it will convert "OLA" to "Ă–stersund".
[Code:lookup:se_region_location]
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".
[Source.Year:lookup:uk_census_year_to_date]

You can convert the result to a different date format by chaining the date transform to the result.

[Source.Year:lookup:uk_census_year_to_date:date:Mmmm d, yyyy]
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".
[Source.Year:lookup:us_census_year_to_date]

You can convert the result to a different date format by chaining the date transform to the result.

[Source.Year:lookup:us_census_year_to_date:date:Mmmm d, yyyy]
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".
[Source.Year:lookup:us_federal_year_to_nara_series]

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:

  1. Split the field into parts spearated by the space character. The result is "1940", "Census".
  2. Search for "Census" in the "us_federal_year_to_nara_series" table. No match.
  3. 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:

  1. Split the field into parts, "Boston", "MA", "USA".
  2. Search for "USA" in the "us_states" table. No match.
  3. Search for "MA" in the "us_states" table. There is a match and the full value is "Massachusetts". Return "Massachusetts".
On This Page