Hi, I have an IF Condition (below) which checks if an Employee Code is in an excel sheet is numeric and if so it proceeds with running through a process. It is all working fine. However I have now come across a situation where the employee code is Alphanumeric. Would anyone be able to give me a s…

@TonyR1 - Here you go… EmployeeCode.IsNumeric or (Regex.Matches(EmployeeCode,“ [1] +$”).Count >= 1) a-zA-Z0-9 ↩︎

@TonyR1 - Click the on the + sign and choose condition builder… and write your condition as below [image]

Apologies, I seem to have put this post in Studio X category instead of Studio. I don’t believe the condition builder is available in Studio (if it is I can’t see it!).

Np…since you posted under Studiox i have provided that solution… check this post… [image] How to check if a string contains alphabets? Help I can check if a string contains an integer but unable to do for a alphabet?

Hi! You can use simply an Is Match Activity with simply “\d” Every string that has at list 1 number in it will be a match

Is it possible to do it using an existing If Activity? I would like to make as few changes as possible to existing automation.

@TonyR1 - Here you go… [image]

Excellent Prashat, I get what you are saying now. How do you apply it to a variable like I had previously? e.g. IsNumeric(CurrentEmployeeCode)?

@TonyR1 - Please mark my post as solution, if it solves your query.

@prasath17 I will testing this later this afternoon and will update you. Many thanks

Alphanumeric Conditon

Help StudioX

park363 (UncleDev) November 25, 2020, 4:18am 11

I recommend follow code.

Regex.Matches(src,“[^\w]+”).Count = 0

this code ‘Regex.Matches(src,“[^\w]+”)’ mean that src string contains characters other than AlphaNumeric.

Topic		Replies	Views
Find into a variable string a char Help	2	1247	January 16, 2019
Using IsMatch for Alpha Numeric variable matching Studio studio , question , variables_management	6	1181	June 22, 2021
How to find whether the string values contains alphabets Studio studio , question , activities_panel	5	4568	May 10, 2023
'Is.Numeric' is not a member of 'String' Studio studio , question , activities_panel	4	1122	January 23, 2023
Find no in for each row Robot robot , question	42	1099	August 17, 2023

Alphanumeric Conditon

Related topics