Welcome to the Functions Library, a collection of reusable content for you to download and use in your own instance of Data Studio. Within this section are templated functions/rules (some of which also containing sample data domains too) for you to use to fast track your time to value with Data Studio. Please note all content in this area is posted in line with our Community Terms of Service, for further information, please check out our FAQs.
Functions Library
Discussion List
-
📋 Index of reusable Functions! 📇This post simply acts as an index for all the functions shared in this library. If you would like t…
-
⌚ Convert Epoch Date/Time to Standard Date/Time⌚ Convert Epoch Date/Time to Standard Date/Time This function was inspired by this post and creat…
-
💡 Submit your ideas 💡If you've got requests for additional functions, domains or reference data that you'd like to see i…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
Standardise Country 🌎Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
Extract First Word 🥇📝This function extracts the first word in a string, in which all words are separated by space. The f…
-
Replace the word ‘NULL’ or any non-null space values with null 🔄👻This function replaces the word ‘Null’ (case insensitive) with a null value. For example, if the va…
-
Extract Last Word 💬🥉 Extract Last Word Version I This function extracts the last word in a string, in which all words a…
-
Parse Date 🧽📅Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…
-
Calculate the distance between two sets of co-ordinates 🌍️ Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…
-
Next ⏭️📅 & Previous ⏮️📅 Working DaySummary The 2x functions contained within this package relate to identifying the last working date …
-
Last day / working date of month 📅Summary The 2x functions contained within this package relate to identifying the last date of the m…
-
👪 Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with na…
-
Offensive Words 🤬Summary The functions contained within this package all relate to flagging and dealing with data co…
-
Mask Out Email/Phone 🛡️Summary This package contains 2x functions to help with anonymising certain input values, whilst le…
-
Proper Case Surname 📛Summary This package contains 2x functions which help with contact data: Proper Case Surname and Va…
-
Get Word ✂️Get Word Extracts the 'nth' word from a string (where 'n' is defined when the function is executed)…
-
Reasonable Date of Birth (DOB) 🔞Reasonable Date of Birth (DOB) [Category: Validation] This function simply checks the input seems r…
-
Standardise Gmail addresses 📧Standardise Gmail addresses [Cleansing] This function is used to help standardise Gmail addresses f…
-
Job Title Match Key 👨💼👩💼Job Title Match Key The function in this post has been designed to help illustrate an approach (and…
-
Invalid Character for Names ☹️Summary This package contains 2x functions: Contains Only Valid Characters for Names & Contains…
-
Compare Dates (Verbose) 📅📅Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…
-
Convert Boolean ✅❌Convert Boolean [Category: Conversion] This function converts a binary or Boolean values (i.e. true…
-
Contains Non-Latin Characters 🈯Contains Non-Latin Characters [Validation] This function identifies the presence of any characters …
-
Reverse String ⏪Reverse String If you find yourself needing to reverse a string (i.e. for bespoke building of anony…
-
PCI Detection 💳 (Payment Card Information)Summary The following package is used to detect payment card information (PCI) and whether it is pr…
-
SIC Conversion 🏷️Summary The following package is used in processing Standard Industry Classification (SIC) codes, a…