I need it in the same excel friendly format. I have to build out my formulas individually in excel and then I'm going to pivot my formula columns within tableau.
As far as ant vs ants, can we allow for plural values but the start of the word has to match exactly?
Late to the party. Sorry for the interruption.
in that case, you can use,
Hi Sanjay, I had tried removing the * but that doesn't change the results.
Here you go!
LEN(REGEXP_REPLACE([Seat From Num],'^[0-9]*$',''))=0
null = null
False = Alphanumeric
True = Numeric
Works by removing all numbers to see if you end up with nothing left