Devam Ediyor

Changes need to data array

I have a 25 mB file with 4 fields (see below) and 900,000 records. At the moment it's a tab-delimited .DAT file. I need to eliminate most of the records and to reduce the file to three fields instead of four, following some simple rules:

STEP 1 - Eliminate unnecessary records

1) If Field 3 or Field 4 is blank, delete the record and look at the next record.

2) If Field 3 or Field 4 contains any alphabet letters (A-Z), delete the record and look at the next record.

3) If the value in Field 2 of the current record matches the value in Field 2 of the previous record, delete the current record (but not the previous record), then look at the next record.

4) Repeat steps 1-3 until all of the records have been examined.

STEP 2 - Combine Fields 1 & 2

1) For all remaining records, combine Fields 1 and 2 into one Field, so if Field 1 contains "US" and Field 2 contains "92084" the new combined field should be: "US92084"

--------------------

Here are the Fields in the original .dat file:

CountryCode MailCode Longitude Latitude

US 30183 34.3217 [url removed, login to view]

US 30127 33.9135

US 31535 31.5046 [url removed, login to view]

The compressed file should look like this:

CCMailCode Longitude Latitude

US30183 34.3217 [url removed, login to view]

US31535 31.5046 [url removed, login to view]

Also, I'd like to keep a copy of the program (so maybe it should be an .EXE file), because I might need to run it again in a year or so on a similar array. The program can be written in any language, I suppose. If it's in PHP, that would a bonus, so I can edit it. Thanks!

Beceriler: C++ Programlama, PHP, Visual Basic

Daha fazlasını görün: need to, need to edit, longitude, latitude, field steps, data longitude, php file array, blank fields, eliminate, delimited data, suppose, edit dat, simple array program, php array file, need copy written, need edit copy, simple program visual basic language, simple program bonus, visual rules, tab data, combine file exe, combine exe exe, visual basic delete records, edit data php, need visual

İşveren Hakkında:
( 13 değerlendirme ) Vista, United States

Proje NO: #735278

Seçilen:

oceeman

Good day! Software already made. Please check PMB.

0 gün içinde 30$ USD
(1 Değerlendirme)
1.0

38 freelancers are bidding on average $48 for this job

zeke

Very easy project, let me start and finish within less than a hour - really simple project. Thank you, Zeke

in 0 gün içinde50$ USD
(171 Değerlendirme)
7.0
guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

in 0 gün içinde30$ USD
(30 Değerlendirme)
6.2
jamalazza

hi please check your pm

1 gün içinde 30$ USD
(36 Değerlendirme)
6.1
wincent

Quick work. ready to start.

in 0 gün içinde30$ USD
(80 Değerlendirme)
6.0
pegla

Hi, check pmb

1 gün içinde 75$ USD
(25 Değerlendirme)
5.3
kamosion

It's veryu simple task for me. I can make less than 1 hour. Can start immediatelly.

in 0 gün içinde50$ USD
(10 Değerlendirme)
5.2
vserv

Can do this easily. Ready to start. Thanks

1 gün içinde 30$ USD
(35 Değerlendirme)
5.1
Manuilov

hello, please, check pmb

in 0 gün içinde49$ USD
(10 Değerlendirme)
4.4
Ahmedn1

Please Check PM

1 gün içinde 30$ USD
(7 Değerlendirme)
4.3
kazaa

Hello I can provide a solution written in php. Please contact me if you have any questions.

in 2 gün içinde30$ USD
(7 Değerlendirme)
4.0
Blackgato

Please see inbox.

1 gün içinde 30$ USD
(4 Değerlendirme)
3.8
WinstonCrawford

Kindly check the PM

1 gün içinde 60$ USD
(2 Değerlendirme)
3.8
genti157

It can be done.

in 0 gün içinde40$ USD
(12 Değerlendirme)
3.8
easyonthemayo

Hello, I can do this for you reliably and repeatably for any file size.

in 0 gün içinde50$ USD
(2 Değerlendirme)
3.4
rizwanfpak

Hi, I am ready to start this project. Please check your inbox for more details. Thanks

in 3 gün içinde70$ USD
(3 Değerlendirme)
3.1
adicosoi

Can be ready really fast. In php if you need it that way.

in 0 gün içinde30$ USD
(3 Değerlendirme)
2.8
look4Work

sir plz check pm !

in 0 gün içinde30$ USD
(7 Değerlendirme)
2.7
PavPS

As result you will get output file and source. See PM. Thx

in 2 gün içinde30$ USD
(1 Değerlendirme)
2.8
leiradel

Pure C application (will deliver both the executable and source code) or Lua (which you can edit and run without recompiling.) Fully commented source code in both cases. No GUI, command line only. Delivery in two hours Daha fazlası

1 gün içinde 100$ USD
(1 Değerlendirme)
2.0
ProgrammerUA

Ready to start right away. Time to deliver: 4 hours.

1 gün içinde 30$ USD
(2 Değerlendirme)
1.8