๐Ÿ’ก Submit your ideas ๐Ÿ’ก

Danny RodenDanny Roden Administrator
edited December 2020 in Functions Library

If you've got requests for additional functions, domains or reference data that you'd like to see in this space please let us know.

When submitting your request, please try to clearly outline what the function needs to achieve e.g. data looks like [THIS] to begin with, and the function needs to do [THIS] in order to make the data look like [THIS].

An example of a good request is below:

I'd like to request a function to convert an alphanumeric string to a date where the input values have had leading zeroes removed (and are formatted as "DMMYYYY" or "DDMMYYYY"). Test values for this function should be "1012000" "12061990" and "6101805" with the results being 'date formatted' values (i.e. "01-Dec-2000" "12-Jun-1990" and "06-Jan-1805").

Equally, if you've got a function you've built that you feel others would benefit from, please feel free to share with us an outline of your function and we'll reach out to you to create an entry for it on the Library which is in line with our documentation standards.



  • Josh BoxerJosh Boxer Administrator

    I had a list of names that were a mixture of Firstname Lastname and Lastname, Firstname that I want to make consistent. Since some of the names were comma separated I used the Extract from list Function step, but unsure if there is a better approach or one that would be more generic for similar scenarios

  • Danny RodenDanny Roden Administrator

    Nice idea @Josh Boxer, I like it. I'll reach out to you directly to discuss how we can get this added to the library!

  • Danny RodenDanny Roden Administrator

    Thanks for your suggestion @Josh Boxer, I've just published a new post (๐Ÿ‘ช Parse Full Name) which includes your function along with a couple of others.

  • Sueann SeeSueann See Experian Super Contributor
    edited June 2021

    @Danny Roden Check this out for a new RIGHT function. Could be one to add into the Functions library. Could also add the LEFT equivalent.

  • Sueann SeeSueann See Experian Super Contributor
    edited May 2022

    Another idea for a function to higlight null/empty values here. This is somewhat a minimal version of conditional formatting in Excel but may be sufficient.

Sign In or Register to comment.