You might try something like:
IF ASCII(LEFT([Names], 1)) >= 65 AND ASCII(LEFT([Names], 1)) <= 122 THEN "Alpha"
ELSEIF ASCII(LEFT([Names], 1)) >= 48 AND ASCII(LEFT([Names], 1)) <= 57 THEN "Numeric"
Hope that helps!
Or, if you only want to have the numeric part for a calculation, then
INT(SPLIT([Product Name], " ", 1))
will give you the numeric value of the first "word" and NULL otherwise. You can either filter out the NULL values or apply other logic. Aggregations will eliminate the NULL values.
Thanks Joshua, That was so helpful but where to perform the remaining Calcation ....Do we use a nested IF or A Case in this case
It would depend on the specifics of how you want to use the result. I may need more details around that.