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 – May 2019

Share this article

4/24/2019: Matching Parent Emails with the Document Identifier

In Relativity, if the Parent Document ID field does not match the Document Identifier (the control number with a link to a document), email threading will not have been performed correctly.

4/25/2019: Javascript to Get PDF page counts

Use a javascript in Adobe Acrobat to get the page counts of multiple PDF files.  The results will be shown in Javascript Debugger.

4/26/2019: Cayman Islands Companies Law Section 238 Valuations

Shareholders that object to a merger can have the value of their shares determined by a Court, but they are held to strict discovery obligations.

4/27/2019: Inclusive Reason Field in Relativity

Check the Inclusive Reason field in Relativity then reviewing emails for which threading analytics have been run.  An entry of ‘Attachment’ means that only the attachment has to be reviewed.

4/28/2019: Lemmatization

The lemma of a word is its dictionary form. So the word ‘go’ is the lemma for ‘going’, ‘went’, ‘gone’ – the various tenses of the ‘headword’, ‘go’. The multiple inflections are collectively known as the lexeme of the word. Lemmatization differs from stemming in that it considers the context in which a word is used.

4/29/2019: Name Normalization in Relativity

Name normalization is a new structured analytics operation in Relativity 10.0 that can be used to identify email address aliases.

4/30/2019: PACER’s One Free Look

Parties can receive one free look at a filing by any party on PACER for up to 15 days after a document is filed, by using a link in an ECF notification email.

5/1/2019: Finding Numbers Stored as Text in Excel

Use the ISTEXT formula in Excel to find which numbers in a column are stored as text.

5/2/2019: Recovery of Deleted Facebook Account

A Facebook account can be recovered for up to 30 days after it is deleted.

5/3/2019: Get a History of Your Blue Screens of Death

BlueScreenView will generate a table listing information about the times in the past that your PC has crashed.

5/4/2019: How Relativity Defines a Number

When you select the option to remove numbers when running a text near dupe identification structured analytics op in Relativity, any word that begins with a number or a non-letter ith. a number as the 2nd character will be removed.

5/5/2019: Getting Bates Numbers Right: Hyphens and Hyphen-minuses

When searching for Bates numbers, note that the hyphen between a letter prefix and the number can be either a regular hyphen or a hyphen-minus.  These two unicode characters may not be read the same by document review platforms.

5/7/2019: Pull Data by Referencing Column Headings on Multiple Worksheets

Use the MATCH and INDIRECT formulas in HLOOKUP to find column headings in different orders on multiple @msexcel worksheets

=HLOOKUP(D$1,INDIRECT(“‘”&$B2&”‘!A:AZ”),MATCH($A2,INDIRECT(“‘”&$B2&”‘!B:B”),0),FALSE)

5/8/2019: 7th Circuit Makes Paralegal Pay Big Law

The 7th Circuit affirmed a district court ruling making a paralegal pay Baker & McKenzie’s fees for her failure to comply with a discovery order in a suit alleging sexual harassment.

Use SUBTOTAL in Excel to Run Calculations on Filtered Data

The SUBTOTAL function makes reference to multiple Excel formulas with numerical codes.   Code 109 is for the SUM formula; 101 for AVERAGE;104 for MAX; 103 for COUNTA.  For example, =SUBTOTAL(109,L2:L22) or =SUBTOTAL(103,L2:L22)

5/10/2019: Get Results Based on Filtered Text Criteria

The result of this formula can change based on which text entries in a cell are selected in a filter.

5/11/2019: Local Rules on Electronic Discovery and the Taxation of Costs

The S.D.N.Y. local rules note that it has reserved judgment on whether or not electronic discovery can taxed as copying costs.

5/12/2019: Convert Video to Audio with ffmpeg

Use the free utility ffmpeg to convert video files to audio only files.

5/13/2019: Sanctions Issued Against Government in Case Where Litigation Hold Notices Were Issued Three Months After Filing of Complaint

Federal Court of Claims issued Rule 37 sanctions against government for deleting evidence as part of an investigation in which documents were created that were marked as work product on a privilege log, showing litigation was anticipated.

5/14/2019: “Too many different cell formats” Error After Copying and Pasting Between Spreadsheets

Copying and pasting data between spreadsheets can cause cell styles to replicate and exceed the Excel maximum and prevent further formatting changes.

5/15/2019: Cyberattacks on Medical Devices on the Rise

Before 2014, less than 1 million personal health records were breached each year.  Since then at least 4 million records have been breached annually.

5/16/2019: OMG WTG PDF

Because they use Javascript and are container files, PDFs are often used in malware attacks

5/17/2019: SHA-1 Is Not Secure

SHA-1 has been shown to be vulnerable to a chosen-prefix attack.

5/18/2019: Use Grep Utility to Collect Full Lines on Which Search Terms Appear

In PowerGrep check off the box for ‘Collect/replace whole sections’.

5/19/2019: Decompounding and Tokenization

Decompounding is an important part of tokenization in German datasets.

5/20/2019: Clustering in Relativity

Clustering operations in Relativity can be run on folders, saved searches, individual documents or the entire workspace.

5/21/2019: globbing

globbing refers to using wildcard characters to search for file names.

5/22/2019: Find and Replace Multiple Lines with ^c

Use the ^c code to add in multiple lines of text in MS Word.

5/23/2019: Google Ads and the GDPR

Ireland’s Data Protection Commission alleges that Google Ads process special categories of data protected by the GDPR.

5/24/2019: E.D. Tenn.: No Threatening Mass of Hackers Using Credit Card Receipts

E.D. Tenn. finds no “threatening mass” of hackers using credit card numbers printed on receipts to make fraudulent online purchases.

5/25/2019: D. Minn.: Embedded Proprietary Information Cannot be Redacted

“That Polymetrix cannot identify line by line what is confidential and proprietary and what is not does not mean that there is not proprietary information embedded therein, or that the specifications and drawings as a whole do not have a value that depends on their being maintained confidential”

5/26/2019 .mig files

Easy Transfer will save all data on a hard drive to a .mig migration file, that can then be accessed on a new Windows computer.

5/27/2019: symlinks

Use the mklink command to create symbolic links in Windows.

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