Em Andamento

Parsing Text Documents for MySQL

# MAIL FROM:all-THISServer RCPT TO:SW-THAT DATA SUBJECT:PRIVATE PROPERTY DIG NOTICE - 324746708 SUBJECT ::PRIVATE PROPERTY DIG NOTICE - 324746708 DIG NUMBER ::324746708 AMENDED DIG NOTICE ::NO CONTACT PERSON NAME ::N I C K POC PHONE NUMBER ::847-303-5800 COMPANY ::U.S. WATERPROOFING COMPANY DIG DATE ::09/08/2003 10:13:00 EMERGENCY ::NO ACTIVITY COMMENT :: FROM STREET NUMBER ::10826 FROM STREET DIR ::S TO STREET NUMBER ::10826 TO STREET DIR ::S TO STREET NAME ::TROY STREET SUFFIX ::ST WARD ::19 LOCATION COMMENT ::SCHEDULED WATERPROOFING TO BE PERFORMED: LOCATORS: LOCATION COMMENT ::WILL YOU LOCATION COMMENT ::PLEASE LOCATE WITHIN (5 FEET) OF THE SOUTH AND EAST LOCATION COMMENT ::WALL OF LOCATION COMMENT ::PROPERTY. OUR FAX HERE IS 403-303-5258. THANKS! DISTRIBUTED TO :: 5, 15, 21, 29, 122, 134, 146, 148 . QUIT I need either PHP or Perl script to parse this file and enter it as a single record in a MySQL database? The first 6 lines of text are not needed. Everything from “SUBJECT?? to the last “LOCATION COMMENT?? are needed as fields in the database. What is on the left of the “::?? can be eliminated I want different field names in the MySQL database. From “DISTRIBUTED TO?? to the end of the document can be eliminated. I have many of these files, each formatted the same way and each file has a unique file name without any extension example: 11244201 [url removed, login to view] SW 20030904 N 324746708 The file name has important information that is not in the document itself. The first 8 digits of the file name represent a key. The next 16 characters need to be stripped away. The “SW?? needs to be saved. The 20030904 is the date need to be saved. The “N?? needs to be saved. The “32474670?? can be stripped away. The Script would have to loop over many of these files and enter a record in the database for each. If a duplicate entry appears it would need to prompt for action: “REPLACE?? or “SAVE AS NEW RECORD?? while showing fields from both records for comparison. A 27 field table in the MySQL database updated daily with this script. 5 fields from the document name 21 fields from within the document and one uniquely generated by the MySQL database. I've had to remove all email symbology from the post with a -

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) The data can either be uploaded as function of the script from the endusers computer or it can be run as a batch form the server one the documents ard sent over. 5) A script that will create the field names and table structure of the MySQL database ready to accept records for the parsing script.

## Platform

Slackware Linux 9.0 Running Apache, PHP, Perl and MySQL The enduser will be on a windows box using IE

Habilidades: Processamento de Dados, Engenharia, MySQL, Perl, PHP, Arquitetura de software, Teste de Software

Ver mais: windows action script, what is record in data structure, what is data entry 10 key, what is a 10 key data entry, the source for linux information, sw data entry, poc document, poc database, poc code, distributed data entry, data structure in computer, data entry form php mysql, computer data structure, what is slackware, slackware linux, linux slackware, k to 12 program, ward, unique text, text parsing, php software structure mysql, key st, dig, wall run script, php code entry mysql database

Acerca do Empregador:
( 3 comentários ) United States

ID do Projeto: #2973713

Premiar a:

stojoman

See private message.

$17 USD em 14 dias
(44 Avaliações)
4.6

31 freelancers estão ofertando em média $61 para este trabalho

ndima

See private message.

$25.5 USD in 14 dias
(96 Comentários)
6.6
marekkilimajer

See private message.

$25.5 USD in 14 dias
(66 Comentários)
5.7
roystervw

See private message.

$42.5 USD in 14 dias
(32 Comentários)
5.1
prasanna123

See private message.

$42.5 USD in 14 dias
(58 Comentários)
5.1
antosgroup

See private message.

$59.5 USD in 14 dias
(27 Comentários)
4.6
ntonyvw

See private message.

$29.75 USD in 14 dias
(18 Comentários)
4.3
vw945703vw

See private message.

$76.5 USD in 14 dias
(22 Comentários)
4.2
uvevw

See private message.

$21.25 USD in 14 dias
(31 Comentários)
4.0
vw905182vw

See private message.

$34 USD in 14 dias
(9 Comentários)
3.2
smastervw

See private message.

$21.25 USD in 14 dias
(4 Comentários)
2.8
tjlytle

See private message.

$63.75 USD in 14 dias
(2 Comentários)
2.5
JamesOConnor

See private message.

$25.5 USD in 14 dias
(2 Comentários)
2.0
vw938212vw

See private message.

$51 USD in 14 dias
(5 Comentários)
1.5
KaloyanYankov

See private message.

$25.5 USD in 14 dias
(1 Comentário)
0.8
ashahawy

See private message.

$42.5 USD in 14 dias
(3 Comentários)
0.0
mwpeters

See private message.

$68 USD in 14 dias
(0 Comentários)
0.0
codermsu

See private message.

$25.5 USD in 14 dias
(1 Comentário)
0.0
biddle

See private message.

$34 USD in 14 dias
(0 Comentários)
0.0
abitar

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0
vw958484vw

See private message.

$25.5 USD in 14 dias
(0 Comentários)
0.0