MeridianMERIDIAN

Email Message-ID

RFC 2822 Message-ID header — a globally-unique identifier for an email message: an angle-bracketed left@right token (<unique@domain>).

Email Message-ID

technology.internet.message_id

RFC 2822 Message-ID header — a globally-unique identifier for an email message: an angle-bracketed left@right token (<unique@domain>).

Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "<30365805.1075860998985.JavaMail.evans@thyme>" --mode column
→ technology.internet.message_id

DuckDB

Detect
SELECT ft_infer('<30365805.1075860998985.JavaMail.evans@thyme>');
-- → 'technology.internet.message_id'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'technology.internet.message_id';

Struct Expansion

Expression
domain: REGEXP_EXTRACT({col}, '@([^>]+)>$')
local: REGEXP_EXTRACT({col}, '^<([^@]+)@')

JSON Schema

finetype taxonomy technology.internet.message_id -o json-schema
{
  "$id": "https://meridian.online/schemas/technology.internet.message_id",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "RFC 2822 Message-ID header — a globally-unique identifier for an email message: an angle-bracketed left@right token (<unique@domain>).",
  "examples": [
    "<30365805.1075860998985.JavaMail.evans@thyme>",
    "<[email protected]>",
    "<[email protected]>"
  ],
  "pattern": "^<[^<>@\\s]+@[^<>@\\s]+>$",
  "title": "Email Message-ID",
  "type": "string",
  "x-finetype-label": "technology.internet.message_id",
  "x-finetype-pii": false
}

Examples

<30365805.1075860998985.JavaMail.evans@thyme><[email protected]><[email protected]>

Aliases

messageidmsgid

Type Registry