Find a string

[Chakravarthy GRK]

Hi All

I want to check if a string ("@") is there in the email address. Also I want to check if the string is starting with any alphabet with any any special character.

Is this something to do with Utitlity strings in the action. Could any 1 advise on this ?

Thank you

 

[Sachin_Kharmale]

Hi Chakravarthy,

You can do above work using regex .
use regular expression as per your requirement .
Use Blue Prism VBO- Utility-Strings Object action Test Regex Match
View attachment 1560861265684.png
Input will be Your text data item and regular expression if expression match it will return true otherwise false

i hope it will help you.

 

[Chakravarthy GRK]

thanx a ton sachin. you are a star. it worked

 

[MadhuG001]

Hi Chakravarthy,

You can do above work using regex .
use regular expression as per your requirement .
Use Blue Prism VBO- Utility-Strings Object action Test Regex Match
View attachment 4135
Input will be Your text data item and regular expression if expression match it will return true otherwise false

i hope it will help you.

Hello Sachin,

In Target String I have entered my data item (Having Email ID), but in Regex Pattern I didn't get what need to enter.
Sorry, but I am not familiar with Regex.
Please advise

Thanks in advance

 

[Sachin_Kharmale]

Hi Madhu,

If you want to validate the email id which is in correct format or not. then use bellow regular expression as Target Regex to Test Regex action
and your input data item as Target String.

Input Regex- "^[a-z0-9][-a-z0-9._]+@([-a-z0-9]+[.])+[a-z]{2,5}$"

View attachment 1562680150071.png

If we enter valid email ID it will return true as output otherwise return false.

I hope it will help you.

 

[Chakravarthy GRK]

^ does this represent. that item (having email) contains a-z or 0-9 . i read somewhere that it is used for negation meaning
it should not contain. but i guess email can have any of that a-z or 0-9 or A-Z for that matter.

can u clarify on that sachin. many thnx