thanks. what is the equivalent of the excel function STXT in tableau ???
Thanks in advance
Looks like that is the name in french for MID()
hope that helps
It depends exactly what you want to achieve here.
Number of Numerical and Alphabetical Characters (a-Z and 0-9)
Number of Numerical Characters (0-9)
LEN(REGEXP_REPLACE(REGEXP_REPLACE([String], '[\D]*',""), '[\D]' , ""))
Number of Alphabetical Characters (a-Z)
LEN(REGEXP_REPLACE(REGEXP_REPLACE([String], '0-9*',""), '[0-9]' , ""))
The above are all on the assumption that the field will only contain alphanumeric characters.