How can i extract the data i got in mail that is 7 digit Employeeid and 5 digit hm_acc_unit column? Please help

Hi @aparna30

Is this a text file or what?

If this is a text file you get them with regex and if possible can you share it here

  • Use Read Text file and store them in the variable
  • Use assign EmployeeID=System.Text.RegularExpressions.Regex.Match(variable,“\d{7}”).ToString
  • Use assign hm_acc_unit=System.Text.RegularExpressions.Regex.Match(variable,“\d{5}”).ToString

This will get you the values

Also you can try like this

  • Read Text file and store in the variable
  • Generate datatable activity pass the string variable here and select the seperators as in the img

and loop through the rows and get each and every Employeeid and hm_ac_unit

Regards
Sudharsan