Litigation Support Tip of the Night - Getting Bates Numbers Right: Hyphens and Hyphen-minuses
Sean O'Shea, RCA, CEDS, CeDP
Legal Assistant at Patterson Belknap Webb & Tyler LLP
Find a 1,001 tips (and counting) on my site, Litigation Support Tip of the Night. A new tip is posted each night.
Recently I received a PDF of list of Bates numbers that I had to look up in a Relativity workspace. I converted the PDF to an Excel spreadsheet using Adobe Acrobat, and copied the column containing the Bates numbers into the field for the document identifier in Relativity. Unexpectedly, the Bates numbers which contained hyphens did not come up in the search results. What went wrong?
One of the Bates numbers from the exhibit list that I couldn't find was composed of these characters [note: these are not real Bates numbers, but the hyphens are]:
XYZ‐000818
However, the Relativity workspace did contain a Bates number as a document identifier that was composed of these characters:
XYZ-000818
What's the difference? It's hard to see but the hyphen or dash between the letter prefix and the six digit number is different. See this analysis in Excel:
The IF . . . THEN formula shows the two Bates numbers are not actually the same. The UNICODE formula reveals that the two hyphens are actually distinct characters.
Unicode 45 is the hyphen-minus character used in cell B1. Unicode 8208 is a regular hyphen used in cell A1. These characters can be read differently by document review platforms and text editors.
Be sure to also account for en dashes – (unicode 8211 entered with ALT CODE 0150) and em dashes — (unicode 8212 entered with ALT CODE 0151).
The views expressed in these posts are those of the owner and do not reflect the views or opinions of the owner’s employer. All content provided on this page is for informational purposes only. The owner 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.