AcuMd5Hash Operator - Haufe-Lexware/haufe.no-frills-transformation GitHub Wiki

Creates an MD5 hash string from input text.

The acumd5hash operator generates an MD5 hash (32-character hexadecimal string) from the input string. This is useful for creating unique identifiers, detecting duplicates, or generating keys based on content.

Returns a 32-character uppercase hexadecimal string representing the MD5 hash of the input.

<Field name="ContentHash">acumd5hash($Description)</Field>
<Field name="UniqueId">acumd5hash(concat($FirstName, $LastName, $Email))</Field>

Note: Records 1 and 3 have identical hashes because they have the same input values.

• Duplicate detection: Identify duplicate content by comparing hashes
• Unique identifiers: Generate deterministic IDs based on content
• Content tracking: Track changes by comparing hashes over time
• Deduplication: Group identical items by hash value

• Uses ASCII encoding for the input string
• Produces uppercase hexadecimal output (A-F, 0-9)
• Same input always produces the same hash (deterministic)
• Different inputs almost always produce different hashes

⚠️ MD5 is not cryptographically secure and should not be used for security purposes (passwords, digital signatures, etc.). It's suitable for checksums, duplicate detection, and non-security-critical unique identifiers.

• The hash is always 32 characters long
• Empty string input produces a valid MD5 hash
• This operator uses ASCII encoding, which may not handle all Unicode characters correctly
• For Acumatica localization-specific hashing, see aculocalizationmd5hash

• AcuLocalizationMD5Hash Operator - MD5 hashing for Acumatica localization
• Concat Operator - Combine strings before hashing