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.
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.
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.
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.
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.
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);
this.extractPages(51,60);
. . . can be used to extract page ranges.
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.
The free download Purrint will automatically prompt you to save an image file after the print screen button is pressed.
*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.