First letter string or Number

sneha_bhiwagade1

Hi Team,

Could you please help me to identify in the data whether the first letter is string or number

Example:-

01234

A0123

@B123

C2345

I want to filter the data based on 1st letter. if the 1st letter is string segregate data in separate. similarly for number and special character

Many Thanks in advance!! 

Raj

@sneha_bhiwagade1 
find the workflow attached

create a new filed using formula tool - IF REGEX_Match(LEFT([YourField], 1), "^[0-9]") THEN
"Number"
ELSEIF REGEX_Match(LEFT([YourField], 1), "^[a-zA-Z]") THEN
"String"
ELSE
"Special Character"
ENDIF


mark done if solved.

3290.yxmd