Closed

Parse Text file - for SQL entry

Parse Text file into comma delimited file.

Sample Input file attached

OUTPUT (example names PARSEMG the calling program)

EQUIPID,FILENAME,DATE/TIME,LINENUMBER,DESCRIBER,VALUE

PARSEMG FILENAME EQUIPID

I.E. PARSEMG [url removed, login to view] 202

EQUIPID - IS A VALUE PASSED INTO THE PROGRAM

FILENAME - IS THE FILENAME PASSED INTO THE PROGRAM TO OPEN AND READ/USE

DATE/TIME - IS THE DATE AND TIME WHEN THE PARSING PROGRAM STARTED FORMAT %Y-%m-%d %H:%M:%S

LINENUMBER -IS THE LINE NUMBER WHERE IT BEGINS A

DESCRIBER - IS THE PORTION STARTING WITH _ GOING TO FIRST =

VALUE - IS WHAT IS AFTER THE = UNTIL THE NEXT _ (TYPICALLY NEXT LINE, BUT NOT ALWAYS)

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

TARGET OS: SOLARIS 5.9

PREFERRED LANGUAGE: PERL

Skills: Anything Goes

See more: package sql, sql server open source, parsing input, open source sql, date hire, open text, text parsing, text file, web parsing program file, open input file, parsing text perl, text sql, sql entry, read sql server, perl file format, per file attached, sql server 2008 installation, input file specified, file format read, perl sql, text file sql server, text file format, sql number format, sql number, read text number file

About the Employer:
( 0 reviews ) United States

Project ID: #3789763

3 freelancers are bidding on average $120 for this job

pixel3cs

See private message.

$110.5 USD in 14 days
(13 Reviews)
4.3
sajidsj

See private message.

$106.25 USD in 14 days
(0 Reviews)
0.0
winterspadeeu

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
mattgiacomini

See private message.

$170 USD in 14 days
(0 Reviews)
0.0