Forum Discussion

MitchTrott's avatar
MitchTrott
Frequent Visitor
2 years ago
Solved

Column format check

Hi all,    I need a custom column to check the values of another column are of the correct format. the format being ABCD1234. If the format is anything different i'd like it to be flagged. I cannot...
Need Help
Tips and Tricks
  • MitchTrott's avatar
    MitchTrott
    2 years ago

    Hi, I have fixed the error with an added IFERROR clause.

     

    Check 4x4 Format =

    VAR text1 = [4x4]

    VAR check1 = LEN(text1) = 8

    VAR check2 = EXACT(LEFT(text1, 4), UPPER(LEFT(text1, 4)))

    VAR check3 = ISNUMBER(IFERROR(VALUE(RIGHT(text1, 4)), BLANK()))

    RETURN IF(check1 && check2 && check3, "Correct Format", "Incorrect Format")

     
    Thank you for your help!!
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

MitchTrott ,

 

so the correct format is having an id with the first 4 characters as ABCD and the last 4 characters as 1234 ?

 

they should all be like that ? 

 

or the correct format is the first 4 characters as text and the last 4 characters as numbers ?

  • MitchTrott's avatar
    MitchTrott
    Frequent Visitor
    2 years ago

    yes format should be 4 capital letters followed by 4 numbers. Thanks