I’m struggling to manipulate below string.
I’m trying to find a way to trim all the strings before the last “” and trim after the whitespace before the word “Exhibit”.
this is to apply this manipulation to rest of my documents.
Any suggestions or help would be much appreciated!
String: C:\Users\leek25\Desktop\UIpath\readwordTest****BEST test LIMITED Exhibit 100 .docx
Expected Manipulated String: BEST test LIMITED