Repeating Characters ๐Ÿ”

Danny RodenDanny Roden Administrator
edited July 2021 in Functions Library

Check for same character repeated

This function 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"). The idea here is to detect cells which are clearly just entered with default values (either through automated processing, e.g. in a previous migration, or through 'keyboard bashing').

See below for a screenshot with some example results displayed (note the length variable is not used in the calculation but presented to highlight some of the test values, particularly one which contains space characters):


This function is compatible with all instances of Data Studio from v2.1.11 onwards.



  • Andreea CAndreea C New Member
    edited September 2021

    Hi, how could we also identify records containing repeating characters? (in this case the repeating character would not be the entire value, but only a part of it)

    For example, if we're looking to identify characters repeating 3 times, how could we identify 'TEEEST', as well as 'EEE'?

    Thank you

    Actually I may have found a possible solution using Transformation and Parse by regular expression ย (.)\1{2}

Sign In or Register to comment.