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!! 

[binu_acs]

@sneha_bhiwagade1 use the regex_match function, include the special characters you are expecting to be separated in the function

REGEX_Match([Data], '^[\d%@].*')

[Raj · Accepted solution]

@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.

[sneha_bhiwagade1]

@Raj Thank you for the solution