nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help with Regex parsing of PDF turned text file

Daniel_Valente

So, I am working on an awesome data set I found:

https://data.montgomerycountymd.gov/Public-Safety/Traffic-Violations/4mse-ku6q?

~ 600k traffic violation over a 3 year period. Lots of things that need re-coding, lots of text data and some interesting geospatial things.

One of the columns is "Charge" which is the actually charge that the driver was given. I found a PDF file of all the IDs, what they are and how much the ticket is for, and how many points the charge is worth. I could only find a PDF, which was converted to a text file (attached).

If anyone has a good idea on how to get this into a JMP table so I can join it against the violations table, that would be really helpful. I think regex parsing is what I will need to make this happen, and then conforming the X XYZ (X) structure of the .txt table into the X.XYZ(X) structure that the charge is.

I put the raw data here, too if anyone is interested: smb://JMPSMD/Users2/Valente-D/TrafficData

Thanks!

dccr090.txt

Accepted answers

All comments

louv

Dan,

I hope this is not because you recently have received a ticket and were trying to benchmark it against other fines.

Lou

DonMcCormack

Dan,

I took a look at the text file and I think the conversion might have altered the format. If you can help with the structure, I can probably put something together with regex.

...unless, of course, you're trying to benchmark a ticket you recently received. In which case, my manager would strictly forbid me to do so.

Don

Daniel_Valente

Hi Don --

I did not get a ticket. Just looking for interesting cross-industry data sets that are messy and large.

Here is the original PDF:

http://www.courts.state.md.us/district/forms/criminal/dccr090.pdf

See what you think. Thanks for your help.

Dan

DonMcCormack

Dan,

This is very helpful. Let me see what I can do.

Don