Suljettu

Make me a script to extract data from a file to a CSV

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.

Taidot: Excel, Scripting, Visual Basic

Näytä lisää: extract data from csv file, perl script extract data excel file, script extract data text file, mine extract data websites csv file, extract data excel csv file, extract data website csv file, script extract data pdf file, php script extract data xml file, asp script import data txt csv file, write script extract meta file data, script extract data file, perl script extract data log file, perl script extract data text file, perl script extract data file, perl script extract data file access

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16359841

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

aarifakhtar

Hi: I have reviewed the details and believe that I can help you with this project. I can create a Excel Macro (VBA) where you can input the folder location. The macro will scan all the files in the folder and extract t Lisää

$30 USD 1 päivässä
(155 arvostelua)
6.9
MohsanEijaz

I can write VB script for Excel that will import data using GREP from a .dcm file in Windows Mohsan

$250 USD 1 päivässä
(67 arvostelua)
6.0
satishtl

- Went through the sample text file pasted. - Can use Excel macros and on button click identify the PN and the DA from each text files and consolidate them into a Excel sheet. - Have done similar text searching autom Lisää

$100 USD 2 päivässä
(41 arvostelua)
5.2
rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Statistics Data Processing Data Collecting (Using Macro) MS Lisää

$25 USD 0 päivässä
(27 arvostelua)
4.9
whitehorsetechn

Greeting, I have understood your Make me a script to extract data from a file to a CSV task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience i Lisää

$100 USD 2 päivässä
(10 arvostelua)
4.5
solucionesnet

Hi, I can develop for you a little windows application for extract the PN and DA values of all files located in a directory in your computer, you only need to select the input dir, the output dir to save the csv file a Lisää

$35 USD 2 päivässä
(11 arvostelua)
4.7
gr8tech

Hello there, I have read your project description and I am available to work on the data extraction required. I have experience working with VBA in Excel for data processing, analysis and automation tasks which is exac Lisää

$25 USD 1 päivässä
(30 arvostelua)
4.5
TetyanaS

I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$30 USD 1 päivässä
(7 arvostelua)
3.6
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Lisää

$25 USD 1 päivässä
(15 arvostelua)
3.5
$100 USD 2 päivässä
(4 arvostelua)
3.4
johnofagbe

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.

$100 USD 1 päivässä
(1 arvostelu)
3.0
naibank

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

$30 USD 1 päivässä
(1 arvostelu)
1.2
tushortz

I can get you the second script with python .

$29 USD 1 päivässä
(3 arvostelua)
1.0
R725

Hi, I am software developer having good hands-on Python and data processing. I can do this task efficiently and on time. I can provide you script which will extract the PAtient details that you would like to get. L Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
vinisaac

I have more than 25 years of experience in web/software development and system administration. My latest work is [login to view URL] Have worked on many simple to complex projects in PHP, Perl, Visual Basic, Ex Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
ShaneP1

A proposal has not yet been provided

$20 USD 1 päivässä
(0 arvostelua)
0.0
aolmoJBS

Hi, I'm an expert in data integration tools. I think that I can help with your project. Can we discuss it in the chat? Regards

$35 USD 1 päivässä
(0 arvostelua)
0.0