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.
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.
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.
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.
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”
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.
Use the mklink command to create symbolic links in Windows.
*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.