I have designed a BOT, which takes the string as input, in what we input some words,then the BOT search those words in a list of files. But the BOT searches for the exact match, eg. If we enter process then it will not select Process or PROCESS. Is there any way to achieve this. As change the string to uppercase or lowercase is not beneficial because don’t know, the words present in the files are in uppercase or lowercase because the files are not fixed.
Thanks all for your response!!
My workflow is like, it will first ask the user to select the method through which he wants to input keywords, that can be Excel File, Text File or Manual input through input dialog box by giving space between each keyword. And for Text File and Manual Input, I have used Split String Method to take the words in a list format and search for keywords one by one.
Then it will ask the user to select the folder from which the BOT will pick the files and one by one pick files and search the keywords and if all the keywords are found then it will move the file to specified folder.
For this, I have used one condition as: FileText.Contains(DT.Rows(Count1)(1).ToString) to pick the column from excel in which, all the keywords are present but with this, it is searching for the exact word. I want to take it as Case Insensitive.
Converting the text to upper or lower will not be beneficial in my case. As I don’t know the words present in files will be in uppercase or lowercase. If a file has a word process, other file has word PROCESS or another file has word proCESS, The BOT should pick all the words.
I want to achieve this, Thanks
The BOT will convert the text to ToUpper but PROCESS and proCESS are not same, so it will not pick the file. There is one more condition, BOT will convert all the text to TOUPPER and suppose, user enters process, BOT has changed it to PROCESS and if the file contains process, then it will not pick the file.
can’t change all the words to UPPER case, if in the file we need lowercase. Correct me if i am wrong.