You can use the below regex to find any whole number, decimal number, or fraction;


[-]?[0-9]+[,.]?[0-9]*([\/][0-9]+[,.]?[0-9]*)*






Litigation Support is on vacation for the next 2 weeks so please be patient with the quality of these tips.

This is a response to a Litigation Support Tip of the NIght visitor who had a problem with the VBA code discussed in the Tip of the Night for March 31, 2018. I re-tested the code tonight, following the steps discussed in the post, and was able to successfully extract metadata from a set of .msg files. The visitor claims that he got an error message reading: "Type mismatch" error when trying to run the Visual Basic code.


This error could result from one or two different mistakes:


If you neglect to check off the Microsoft Object Library in Tools . . .. References as discussed in the first step of this tip, you will get this error:



If the folder holding .msg files to be processed does not have any .msg files, this error will be returned:



In an Access database you can easily get a list of the unique values in a column by running a SQL command.


  1. This table contains multiple entries for many city names:



2. To get a deduped list go to Create . . . Query Design, and select 'SQL View' at the left of the toolbar.


3. Enter the following SQL command:

SELECT DISTINCT Olympics.City

FROM Olympics


The command SELECT DISTINCT picks a field in a table, and then FROM pulls that field from a designated table.


4. Click Run, and a new query will be generated listing each value in the table only once:




Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

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.