In a Microsoft Excel spreadsheet cell one can use a custom function to effectively grab all test after the final (last) occurrence of a particular character or string. This is accomplished by simply creating a Custom Function and then using that function in a cell formula. Following is the code and instructions for how to create and then implement the function.

Insert a new module by right-clicking on ThisWorkbook > Insert > Module or on the toolbar clicking Insert > Module

Paste the clipboard contents (which is the code above this numbered procedure) into the code window by pressing CTRL-V, or by right-clicking in the code window and on the popup menu clicking on Paste, or by clicking the menu toolbar on Edit and clicking on Paste.

Close the Visual Basic Editor by presing CTRL-Q, or by clicking File on the menu toolbar and then clicking Close and Return to Microsoft Excel.

The custom user defined function is now available to be used in the formulas of cells. To use it, the following syntax format is used in the cell’s formula:

=PullAfterLast(A1,"yourstring")

Of course, replace yourstring with the appropriate character or string.

This will download a file called Mpas-fe.exe
Try to save the file in a location that you can get to easily with a command prompt. (ie. C:\ )
Then, open a command prompt and run the program using the -q switch. It looks like this:

Mpas-fe.exe -q

The program will run quickly, and won’t give you any kind of confirmation that it has run or finished.

Open the Microsoft Windows Defender window to see what date your definition files have. This is how you can be sure that the update was successful.

IMPORTANT: The above info applies ONLY to 32-bit Operating Systems. For those of you using 64-bit platforms, see the full scoop here:

This procedure assumes: “Files”-type rip of DVD to decrypted VOB using DVD Decrypter

DVD Shrink

Click button Open Files

Navigate to the VIDEO_TS subfolder of the directory that holds the DVD’s decrypted VOB files.

Click button Re-Author

Drag titles from the right-hand pane to the left-hand pane.

To trim: on left-hand pane items, right-click and click Set Start/End Frames…

Set the beginning and ending frames of the segment that you want to keep.

Click button Backup!

Flask MPEG

File >> Open DVD. Find your IFO file made when you trimmed the VOBs

Select the streams you want to include, click Flask this DVD!

Options >> Global Project Options

Video tab

Frame Size – This dictated the output resolution of the video, as far as quality goes. It does not dictate the viewing size of the video, since this MPEG-1 video is locked in at 352 x 240 for viewing. What this means is that this setting controls video qulity only.

Files tab – set the path and filename for output video.

General Tab

Compiling Time – you can compile the first n frames/seconds of the project, instead of the whole thing. Good for testing settings.