๐Ÿ“‹ Index of reusable Functions! ๐Ÿ“‡

Danny RodenDanny Roden Administrator
edited February 16 in Functions Library

This post simply acts as an index for all the functions shared in this library. If you would like to receive a notification whenever a new function is added, please bookmark this post by clicking on the star icon to the right. Current functions available:

  • ๐Ÿ‘ช Parse Full Name - A handy set of functions that can help standardise the sequence full names are presented in (e.g. "surname, forename" vs "title forename surname") and can extract individual name elements (title, forename, middlename and surname) using logic.
  • Next โญ๏ธ๐Ÿ“… & Previous โฎ๏ธ๐Ÿ“… Working Day - As per the name, these functions detect the next working day after (and previous working day before) a given input date.
  • Last day / working date of month ๐Ÿ“… - These functions identify the last day (and last non-weekend day) of the month for a given input.
  • Parse Date ๐Ÿงฝ๐Ÿ“… - This configurable function allows the user to specify a date format string and then it auto-parses in line with that specified format.
  • Standardise Country ๐ŸŒŽ - The function uses reference data (contained within the .dmxd file) to standardise known country aliases to the standard form (e.g. England = United Kingdom).
  • Offensive Words ๐Ÿคฌ - The functions contained within this package all relate to flagging and dealing with data containing offensive language. All of these functions uses a domain of offensive words (contained within the .dmxd package) which contains a list of known offensive terms.
  • Mask Out Email/Phone ๐Ÿ›ก๏ธ - This package contains 2x functions to help with anonymising certain input values, whilst leaving an output that can still be used for non-sensitive analysis.
  • Proper Case Surname ๐Ÿ“› - This package contains 2x functions which help with contact data: Proper Case Surname and Validate Surname Casing.
  • Get Word โœ‚๏ธ - Extracts the 'nth' word from a string. Where n = 2 the second word is retrieved, where n = -1 the last word is retrieved.
  • Reasonable Date of Birth (DOB) ๐Ÿ”ž- Checks the input is a value which seems reasonable as a valid date of birth using user defined min/max age parameters (i.e. a date, not in the future, related to an individual within an age bracket of 16-100 years old)
  • Standardise Gmail addresses ๐Ÿ“ง - Standardise Gmail addresses for matching purposes (e.g. googlemail/gmail as well as email addresses associated with the same account via the use of '+' and '.' in the account part of the email)
  • Job Title Match Key ๐Ÿ‘จโ€๐Ÿ’ผ๐Ÿ‘ฉโ€๐Ÿ’ผ - Generates a key that can be used to group job titles together (despite presentation differences)
  • Invalid Character for Names โ˜น๏ธ - Finds records where the field contains characters which are invalid for names. Records which contain digits, commas, and other special characters will yield a "true" result. Apostrophes, dashes and periods are not considered "special characters" for this function. This function is not suitable for Validation Rules -- use "Contains Only Valid Characters for Names" instead.
  • Compare Dates (Verbose) ๐Ÿ“…๐Ÿ“… - Provides a summary of how 2x input dates compare (includes 'convert to date' logic). Output options are: Exact match, Incomplete - Date 1 is missing (or not a date), Incomplete - Date 2 is missing (or not a date), Incomplete - Both dates are missing (or not a date), Close - Day & Month match, Close - Month & Year match, Close - Day & Year match, Other difference
  • Convert Boolean โœ…โŒ- Converts binary or Boolean values (i.e. true/false, pass/fail, 1/0) to a graphical emoji icon to aid visual presentation in the UI.
  • Contains Non-Latin Characters ๐Ÿˆฏ - Identifies the presence of any characters not in the 'basic Latin' unicode block.
  • Reverse String โช - Reverses the input (e.g. "Danny R" becomes "R ynnaD")
  • Repeating Characters ๐Ÿ” - Uses a regular expression to identify records where the entire value of a cell is made up of the same character repeated (e.g. "aaa" or "0000000").
  • PCI Detection ๐Ÿ’ณ (Payment Card Information) - Checks that the input contains 16 char numbers (either as a single string or separated with hyphens/spaces every 4 characters) [AmEx format also accounted for]
  • SIC Conversion ๐Ÿท๏ธ - Takes a 2007 format SIC code as an input and returns the high level label of the 'category' of businesses which it falls into.
  • Future Date Check ๐Ÿ“… (Dynamic) - Checks that the input date is a date in the future (relative to the time of execution).


This discussion has been closed.