I’ve found a way to do what you are looking for! After been working on it for hours
So check this out
I use regex, to look for numbers after the word “ISO” on the subject and the body of the mail. If there’s any it will continue, so that you can add what ever you want, like getting the code and use it on the web and send the mail. If not it will do nothing !
HI
welcome to UiPath community
both way runs at same pace. so we can go for the first method itself like
get all the mailmessage as a list and iterate through them one by one in a FOR EACH activity
Here you go with an xaml
hope this would help you resolve this regexx (2).zip (30.2 KB)
Thanks…I am able to get the value either in the subject or the body and store into a variable.
Now i have another task
-Read existing Csv starting with row b2 and read each row to see if the text in the cell contains the variable and also contains a certain string ( lets say contains Variable as well as string(USA)
if it contains the variable and the string then store that cell number into another variable ( say it finds the variable and the string in cell b5 then store b5 into a variable )
– Later, use a dataTable.Select(“ ColumnName <> ’Var?’ ”).copytodatatable() , than save it using a Write Cell…
Would this be an assign activity after i read the range and store into datatable? Or is this a datatable activity? Also how does this search each row for my variable and string? Im a little confused.
ok so dataTable.Select(“ ColumnName <> ’MyVariable?’ ”).Copytodatatable()
Is this where i would put my variable to search? And Also where do i put my string to search for the phrase or word USA? Or am i getting ahead of myself?
Can i do something like this?
Inside excel application scope
Read Range B2 output to dtAllLinks
Assign dtAllLinks if the variable IsoSubjectFound and also the string USA is found.
I get compile error string constants must end with a double quote
Also the string in the excel row i am reading is a link to a website so i think i need to use Contains variable and also contains USA. The link would be a long link that has both the variable name and USA in it along with other characters.
I am also having similar task and downloaded the program “SearchByKeyWordOulook”.
I am unable to run the program. Seems, few activities are missing.