My scenario here is I have a text file with more than 500 lines. In need the text from last 20 lines.
Kindly help me with a solution. Thanks in advance
You could create workflow which will scroll down to the bottom of text file. Then it would click last line to move cursor there. And send hot key like Shift + up arrow (20 times) to mark 20 lines.
Thanks for your solution
But it need to be done without opening the notepad
You can use “Read Text” activity, split the text for every newline into a list and use a loop with index starting from (count of the list-21) till (count of the list -1). You can declare an empty string and use assign inside the loop like emptyString = emptyString+splitList[index]+vbnewline. You can use Enumerable.range(splitList.count()-21,20) inside for each loop. emptyString after the completion of loop will contain the last 20 lines of your text
This method is messy but I guess it’ll suit your requirements.
You can also do this with powershell:
- My file looks like this (I specially made number for each line)
- Then workflow with script.
Tail -5means that it will catch last five lines. The output of script is kept in
outputvariable. Type Argument for powershell is set to String and IsScript property is marked.
- And the final effect