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