Closed

Extract Large Text file into excel and format in excel

This project was awarded to gangabass for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
31
Project Description

I have a very large TXT file (~3+ Gigs) that I need someone to be able to open up and extract each line into excel.

Each line is about 1281 characters. After each line is in Excel, I need to split up each line into separate columns based on a set number of characters.

For instance, let's say the first line is in Cell A1. I need characters 1 - 5 to go into Cell B1, characters 6-13 need to go into cell C1, characters 14-21 to go into column D1. I've listed the entire character instructions at the bottom of this description.
Here is the file that I need you to extract and format: [url removed, login to view]

I will need you to send me 2 files: The excel file with each line in one column, and the final excel file with multiple columns.

If you are interested, 1) send me a sample to show that you can do it 2)And tell me how long it will take you to do.

Here is the order of the characters: (first line in column 1, second line (6-13) in column two and so on...):
1-5
6-13
14-21
22
23-26
27
28-29
30-40
41-48
49
50-57
58-64
65-70
71-420
421-470
471-510
511-550
551-574
575-589
590-599
600-649
650-689
690-729
730-753
754-768
769-778
779-1128
1129-1168
1169-1208
1209-1232
1233-1247
1248-1257
1258-1281

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online