I have created a workflow in which BOT will read the Text file and in the text file, BOT needs to perform multiple replacements. And the values for replacements, BOT will pick from the excel file.
Now, multiple replacements I can perform like: NotepadText.Replace(oldvalue,Newvalue).Replace(oldvalue,Newvalue) and so on.
Like this, I can perform multiple replacements but my requirement is: I need to perform multiple replacements where excel can have “n” number of columns and also “n” number of replacements could be performed. I want to make the solution dynamic.
I have an excel file with say 100 records and 10 columns. Now I would need to perform 10 replacements for these 100 records. The text from which I need to replace the text is in the text file and the text to which I need to replace text is in excel file. How this method will be used in that case.
For this, I would need to write 1000 rows, 10 for each record. And also the number of columns is not fixed. It can be 1 , 10 or even 100.