Data Manipulation with Strings. How can solve that below question

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
Input Text k.txt (1.3 KB)
Input.xlsx (8.9 KB)

Would you like to send me complete solution

2

@Kailash_Singh,

What’s the issue you are facing here?

3

Where file names will be the keywords how make the sheet as keyword
_1 and keyword_2

4

From what I have understood from your Problem Statement.
Here you go:
Main.xaml (11.5 KB)