I need EITHER:
a) a VB script for Excel that will import data using GREP from a .dcm file in Windows (I can read in a Text editor) to a spreadsheet.
b) a script that will parse through a file and export the same data to a CSV.
I just need the script. I will run the script. I can give you a couple of examples to test on your side but this is patient data so I will be running the script. I just need your guarantee it will work on my end.
The data looks like this:
································································································································DICM····UL··°·······OB··········· ·UI··1.2.840.[url removed, login to view]·····UI&·1.2.392.12345.1.[url removed, login to view]····UI··1.2.840.[url removed, login to view]·····UI··1.3.[url removed, login to view]····SH··Radlink CR Pro·· ··UL··ô·······CS ·ISO_IR 333····UI··3.2.830.[url removed, login to view]·····UI&·1.3.392.32335.1.[url removed, login to view]·· ·DA··12345678··0·TM····P·SH····`·CS··CR··d·CS··DF· ·p·LO··Radlink···€·LO··BLAHBLAH Blah····PN······SH····0·LO··R hand···LO··Radlink CRPro·····UL··V·······PN··JOHN_DOE^^^·· ·LO··431368···0·DA··12345678··@·CS··M·····LO····°!LT······UL··V·······CS··Foot - Lateral-Medium···`·DF··70····DA··23303332····TM······DS··40··S·IS··3123 ···UL··|··· · ·UI&·1.2.392.1
I need to extract out the PN (Patient Name Example JOHN_DOE) and DA (Patient ID Example 12345678) from these files. I need to run it as a batch as there are 18,000 files. The PN and DA are always in the first 3 lines of the file. There are some files which dont include this data so if it does not find the data it can move on to the next file.
I have seen very similar VB scripts for Excel I can even share with you. You just need to modify a couple things to make it work. I'm guessing someone knowledgeable can do this in 15 min
Once I have a quote I will pick someone probably on Monday or Tuesday (2/26/18 or 2/27/18) to work and complete this.
17 freelancers are bidding on average $58 for this job
Hello, I am John Ofagbe, a professional web developer and software engineer. I have read through your project description and I can get this done within 2 days.
Hi I am very familiar with the text extraction using R script. I won't say I can finish in 15 minutes but it will be within an hour. Hope to work with you. Thanks, Worrawat