I have a project how we can do that anybody help please,

Help Studio
, ,
1
  1. Read the Input Excel File provide by the User.
  2. Read the Input Text File.
  3. Based on the Keyword Provided in the Input File, search In the Text File provided and split it.
  4. Create an excel file where file name will be the Keyword and make the Sheet as Keyword_1, Keyword_2 based on the results you will get after splitting.
  5. For each Input Keyword there must be a different Excel File.

Note:

  • If the Keyword does not exist In the text file, it should give proper Message as the Keyword is not present instead of giving Exception.
  • Also, include Exception Handling in this Assessment.
2

@Kailash_Singh

  1. read range activity
  2. read text file and store ins tr
  3. for each row in datatable
  4. inside loop use if condtion to first check if word is present str.contains(currentrow("ColumNname").ToString)
  5. on then side you can split string and write to datatable usign assign
  6. on else side do nothing write string not found

cheers

Text file & Excel file
3

can you send me activity for complete solution