I had a large number of ebooks that looked like the following:
Walter%20Isaacson%20-%20Einstein_His%20Life%20And%20Universe.mobi
And because I’m lazy, I looked for an automated way to clean all of them up. This is how:
1. Back up all your files in another directory
2. Launch terminal
3. Go to the directory you’d like to perform the changes
4. Type: for i in *.mobi; do mv "$i" "`echo $i | sed ‘s/%20/ /g’`"; done
5. That’s it!
The key is to use a macro. To do so, hit Alt+F11, then create a new macro and add the code below. Once added, select the worksheet you’d like to process, change the “17” below (1 if to process all rows), then run it.
That’s it.
Sub Insert_Blank_Rows()
Dim Last As Integer, oRow As Integer
‘Count and select rows to process
Last = Range("A" & Rows.Count).End(xlUp).row
’17 is the last row to process (at the top)
For oRow = Last To 17 Step -1
If Not Cells(oRow, 1).Value = "" Then
‘Copy the line below to as many row insert you need
‘in this case, it was 3 row inserts
Cells(oRow, 1).EntireRow.Insert
Cells(oRow, 1).EntireRow.Insert
Cells(oRow, 1).EntireRow.Insert
End If
Next oRow
End Sub
PS C:\workspace> (gc “fileToParse.txt”) -notmatch "<criteria>" | out-file
"resultFile.txt"
Note: <Criteria>, for example, “not".
1. Open PowerShell
2. CD into directory to work on
3. Execute the following command:
get-childitem * -recurse | rename-item -newname { $_.name.ToLower() }
1. Open PowerShell
2. CD into directory to work on
3. Execute the following command:
get-childitem * -recurse | rename-item -newname { $_.name -replace ".txt",".bcp" }