Anyone got easy ways to make sure a text is only numbers and letters?
Solved! Go to Solution.
Itโs very difficult to find all characters that you donโt want. Because there are many
You could also do this:
COUNT(
LIST(
MID([YourTextColumn],1,1),
MID([YourTextColumn],2,1),
MID([YourTextColumn],3,1),
MID([YourTextColumn],4,1),
MID([YourTextColumn],5,1),
MID([YourTextColumn],6,1),
MID([YourTextColumn],7,1),
MID([YourTextColumn],8,1),
MID([YourTextColumn],9,1),
MID([YourTextColumn],10,1)
)
-LIST(
"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",
"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z",
"0","1","2","3","4","5","6","7","8","9"
)
)
If this is greater than 1, then there is a special character.
This is working for a text length up to 10. But you can expand it.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |