Lukket

Extract data from txt/xls/doc file

I have a doc file that has a list of (60,000+)? items that appear in 70? high school yearbooks. I have converted it to txt? and xls. I don't know which would be better for you to get the data from.

Sample lines? look like this:

STUDENT------

Zoblosky, James (ARC1952), 45, 108

Zoblosky, James (ARC1953), 46, 79, 82

Zoblosky, James (ARC1954), 31, 86, 90

Zoblosky, James (ARC1955), 29, 32, 86, 106, 110, 130

STUDEN with Nickname-----

Webb, Willie (Billy) (ARC1949), 23, 67, 69, 76

STUDENT with lasr name suffix-----

Watson, Earl D, Jr. (ARC1963), 110, 226

should ecome Warson Jr.

ADVERTISER-----

Zeisig’s Grocery & Market (adv.) (ARC1956), 197

FACULTY-----

Youngblood, Johnny W. (ARC1969), Faculty, 40, 76, 205, 208

Youngblood, Johnny W. (ARC1970), Faculty, 75, 182

OTHER-----

Yaupon Garden Club, Vienna Trip Donor (ARC1973), 169

Yeager, Gay, Mrs. (ARC1965), 12

This is not a student, (anything with Mr. or Mrs.)

Watson, P. O., Mrs. (ARC1951), 120

Watts, John, Jr., Mr. (ARC1979), 172

Watts, John, Sr., Mr. (ARC1979), 172

Unknown First Name-----

Wyse (ARC1929), 19, 27, 29, 30

This? will give me? xls? lists of? names? with class years with page number of photos for each.?

STUDENT Spreadsheet

Each? STUDENT gets one line with multiple fields.? This an example I am thinking of.

Last Name

First Name (other than last name -e.g. Donald Ray)

Nickname

Last (or highest) Class Year

Class Yaer 2? (next highest)

Class Yaer? 3? (next highest)

Class Yaer? 4? (next highest)

Class Yaer? 5? (next highest)? .... as many as needed

Class Years (range e.g. 1954-1959)

ARC Year-Page 1 (1954-023)

ARC Year-Page? 2 (1954-065)

ARC Year-Page? 3 (1954-066)

... as many as needed

Some students have name mispellings, or more formal full name in last year. I will have to do some manual editing for this.? ?

Someday we will? have all yearbooks scanned, and will want to link a name to? all of a? student? images to display? on a single? web page.?

Iimage name format? is this:

[url removed, login to view] ([url removed, login to view])

Spreasdheets for:

FACULTY

TRUSTEE

ADV

PHOTO(S)?

STAFF

OTHER

## Deliverables

I have very poor vision, thus the requirement for Excel 2000.?

Eventually this will become part of an MS SQL database. Keep this in mind while creating? field names.

?

* * *This broadcast message was sent to all bidders on Sunday Oct 19, 2008 6:21:23 PM:

NOTICE: I added the txt file to the bid. Thanks for the excellent feedback!

* * *This broadcast message was sent to all bidders on Sunday Oct 19, 2008 8:27:59 PM:

I am removing all street addressrd in the list. This will take a little while but will remove thousands of lines of data.

* * *This broadcast message was sent to all bidders on Sunday Oct 19, 2008 10:05:45 PM:

Please take note of the revised txt file. Removed street, avenue, and drive listings.

* * *This broadcast message was sent to all bidders on Monday Oct 20, 2008 1:56:04 PM:

Notice to those sending Comments without making a bid: This project is important to me, but does not require much effort by a good coder. Right now I have many good low bids to consider. I noticed a problem in the data that I need for you to find a solution, in addition to the other criteria. Some Student Names are Father and Son. They must be separate items in the list. The key pattern that can be used is built around the number of years between the Class Year. If it is more than 4-8 years, it is probably a son 20+ years later. Look at Abbott, Elias. In the 1910-30's, many young men did not go to achool continuosly because of farm work and the Depression. Find a way to identify Father/Son names, and don't merge them as one. Elias Abbott did not attend school from 1927-1962.

Evner: Ingeniørarbejde, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Projekt Ledelse, Software Arkitektur, Software Testning, Word

Se mere: young's market, web photo management, txt 2 jpg, staff requirement, school project first page, school 2008, one key data, james list, high school 2008, example of number problem with solution, doc note, abbott, 2008 school, xls, webb, Vienna, txt, student data, staff photos, school on line

Om arbejdsgiveren:
( 1 bedømmelse ) United States

Projekt ID: #3321714

22 freelancere byder i gennemsnit $321 på dette job

fastudiovw

See private message.

$204 USD in 14 dage
(731 bedømmelser)
7.5
bridgetime

See private message.

$255 USD in 14 dage
(20 bedømmelser)
5.9
hinoglu

See private message.

$272 USD in 14 dage
(39 bedømmelser)
5.5
BrothersTeam

See private message.

$561.85 USD in 14 dage
(72 bedømmelser)
5.3
wangpretty

See private message.

$170 USD in 14 dage
(27 bedømmelser)
5.3
techism

See private message.

$204 USD in 14 dage
(45 bedømmelser)
4.7
mahfuzmurshed

See private message.

$42.5 USD in 14 dage
(74 bedømmelser)
4.6
tajvisteam

See private message.

$850 USD in 14 dage
(19 bedømmelser)
4.2
jvavadiya

See private message.

$170 USD in 14 dage
(19 bedømmelser)
4.1
aymaninho

See private message.

$17 USD in 14 dage
(16 bedømmelser)
3.1
Platinum111

See private message.

$500.65 USD in 14 dage
(3 bedømmelser)
2.8
realcodingvw

See private message.

$764.15 USD in 14 dage
(3 bedømmelser)
2.6
tinkercompany

See private message.

$1700 USD in 14 dage
(6 bedømmelser)
2.2
jsemmanuelvw

See private message.

$85 USD in 14 dage
(1 bedømmelse)
1.9
vbguru1vw

See private message.

$85 USD in 14 dage
(1 bedømmelse)
1.1
asasivw

See private message.

$34 USD in 14 dage
(0 bedømmelser)
0.0
maverickdesign

See private message.

$425 USD in 14 dage
(0 bedømmelser)
0.0
bosycath

See private message.

$21.25 USD in 14 dage
(0 bedømmelser)
0.0
kcdesivw

See private message.

$59.5 USD in 14 dage
(0 bedømmelser)
0.0
yodaj007x

See private message.

$12.75 USD in 14 dage
(0 bedømmelser)
0.0