Justice and Law concept. Legal counsel presents to the client a signed contract with gavel and legal law or legal having team meeting at law firm in background

Sean O’Shea: Tips for Paralegals and Litigation Support Professionals – March 2019

Share this article

2/27/2019: Get Counts of Files in Multiple Subdirectories

In the command: dir /a /s | findstr “Directory File(s)”    – findstr filters the results.

2/28/2019: Export Highlighted Text from Multiple Transcripts to Spreadsheet

You can use an Adobe action to export a summary of all comments in multiple PDFs.

3/1/2019: Court of Appeal of Louisiana Affirms Denial of Injunction to Preserve Online Data Providers Offers to Retain for a Fee

A preliminary injunction denial was affirmed where a ShareSync account could be retained for a fee, and metadata could be preserved by another IT provider.

3/2/2019: Repeated Content Filter Types

Regex searches can be used in repeated content filters in Relativity Analytics.

3/3/2019: Creating an Excel Workbook and Naming Worksheets

Use the Workbook class of the openpyxl module to create an Excel workbook and name its worksheets.

3/4/2019: W.D. Wash. Reduces Fees for Block Billing and Redactions to Billing Descriptions

Fees were reduced by 10 % for block billing, but the moving party was not penalized for submitting billing records as Excel files.

3/5/2019: 3-D References to Multiple Worksheets

In Excel 2013 and higher, you can reference a worksheet range in order to the values from cells common to each worksheet.  E.g., =SUM(Sheet1:Sheet2!B2)

3/6/2019: What is the Difference Between the Record on Appeal and an Appendix?

In appellate filings the record on appeal contains all relevant court filings and evidence, but the appendix only has portions of the record to be focused on for the purposes of the appeal.

3/7/2019:  District of Delaware’s Access to Source Code Standard

Source code must be made available on a stand-alone computer, and scripts, compilers, and assemblers must be provided to rebuild the application from the code if there is an issue of missing files.

3/8/2019: Massachusetts Supreme Judicial Court: If Proof Beyond a Reasonable Doubt that Defendant Knows Password No Violation of Fifth Amendment Rights

LG phone records, a party’s statement that she communicated with the defendant on this phone, and the defendant’s own admission to the police that the phone was his, were enough to prove beyond a reasonable doubt that he knew the password.

3/9/2019: District of Utah Issues TRO for FTC to Take Expedited Discovery

District of Utah grants FTC expedited discovery in a computer fraud case.  Depos to be taken with 5 days notice; RFPs for ESI must be responded to in 3 days.

3/10/2019: Special Master Ruling on Request for Bayer Lotus Notes Litigation Archive

Special master did not require Bayer to produce a ‘Lotus Notes Litigation Archive’, created six years before notice of litigation, which it could not locate.

3/11/2019: Estimating Database Diskspace in Relativity

Relativity states that on average the database diskspace will take up 10 GB for every 10,000 documents.

3/12/2019: Elusion Tests

Relativity can run an elusion test to check documents ranked as non-responsive for those which should be coded as relevant.

3/13/2019: Generating HTML Tables

Demonstration of how columns can be added to sortable HTML tables.

3/14/2019: Get a list of Excel column headings

this formula =LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1 will generate column headings up to ZZ.

3/15/2019: Find and Replacing Multiple Strings in a Word Document

The macro works with a table with two columns.

3/16/2019: Merkle–Damgård construction

The MD5 and SHA1 hash functions use the Merkle–Damgård construction to take message inputs of variable length and generate a fixed length output.

3/17/2019: District of Maryland Denies ESI Spoliation Motion

For custodians whose emails the Plaintiff was able to show were printed and placed in personnel files, which were not included in the ESI production, the Court denied the spoliation motion where the Plaintiff failed to show that the emails were printed after the duty to preserve arose.

3/18/2019: ISO 9660 and UDF Standards for Electronic Media

A disc in the ISO 9660 format can use file names of up to 32 characters.  The UDF format for optical discs allows for 255 character file names.

3/19/2019: Ranks NL

Stop word list recommend by Relativity

3/20/2019: Western District of Kentucky Grants Motion to Compel Cross Border Discovery from Russia

Federal court decision granting motion to compel discovery from Russia on basis of FRCP instead of using letters rogatory.

3/21/2019: Saving Text from PDFs of Condensed Transcripts to Text Files

You can use Abby FineReader’s Draw Text Area tool to save the text of a condensed transcript to a text file with the correct page and line number order.

3/22/2019: makecab command

The Windows makecab command can be used to compress files.

3/23/2019: Working with Java scripts in Adobe Acrobat

This script: this.extractPages(21,30);


. . . can be used to extract page ranges.

3/24/2019: NirCmd

Use NirSoft’s free nircmd utility to clear the clipboard, close explorer, and speak the contents of the clipboard from the command line.

3/25/2019: Saving Screen Grabs Automatically As Image Files

In Windows 7, you can use an AutoHotKey script running a nircmd command to auto save screen grabs as image files.

3/26/2019: Purrint

The free download Purrint will automatically prompt you to save an image file after the print screen button is pressed.

Sean O'Shea on Email
Sean O'Shea
Litigation Paralegal
Sean O’Shea began working as a litigation support analyst at Brobeck, Phleger & Harrison LLP in 1998, near the dawn of the electronic discovery era. From assisting clients with the implementation of information governance policies, to conducting electronic presentations for attorneys at trials, he has been involved in all aspects of litigation support work. Sean is a Relativity Certified Administrator and an ACEDS Certified E-Discovery Specialist. He’s currently employed as a litigation paralegal in New York City, and continues to advise attorneys on legal technology. Look for a new tip on each night on www.litigationsupporttipofthenight.com.

*The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer. All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. This policy is subject to change at any time. The owner is not an attorney, and nothing posted on this site should be construed as legal advice. Litigation Support Tip of the Night does not provide confirmation that any e-discovery technique or conduct is compliant with legal, regulatory, contractual or ethical requirements.

Share this article