point validation "." or "-"

DEVIMPLOY_Autom_0-1653071761742.png

want that when it is typed in this way it validates that it has two digits before the "." and three after the "." . column type text and maximum 6 digits

Solved Solved
0 1 58
1 ACCEPTED SOLUTION

You want to make sure there are 6 digits and a dot or dash on the third position?

AND(
  LEN([_THIS])=6,
  IN(
    RIGHT(LEFT([_THIS], 3), 1),
    LIST(
      ".",
      "-"
    )
  )
)

Notice that there are always different ways to do this 

View solution in original post

1 REPLY 1

You want to make sure there are 6 digits and a dot or dash on the third position?

AND(
  LEN([_THIS])=6,
  IN(
    RIGHT(LEFT([_THIS], 3), 1),
    LIST(
      ".",
      "-"
    )
  )
)

Notice that there are always different ways to do this 

Top Labels in this Space