In Progress

Extract Large Text file into excel and format in excel

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

Skills: Big Data, Data Entry, Data Processing, Excel, Software Architecture

See more: extract large text file, gigs on line, 5 gigs, 2 gigs, how to send dropbox files, excel split columns, excel split a cell, data processing in excel, c1, extract data excel file, split file, extract excel files, excel can open file, excel split, excel format cell, excel cell format, excel instance column, column text, excel file columns, extract data text, format cell, excel text column, excel split cell, www com gigs, excel text columns

About the Employer:
( 37 reviews ) Los Angeles, United States

Project ID: #4311385

Awarded to:

gangabass

I have completed it. See PMB for details.

$50 USD in 0 days
(110 Reviews)
5.7

31 freelancers are bidding on average $117 for this job

FINGERRPRINT

I have gone through your project description and we are interested in working in your project. Please check your inbox.

$250 USD in 7 days
(116 Reviews)
7.0
sergioes

Hi, I'm an excel expert.

$30 USD in 2 days
(211 Reviews)
6.8
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD in 7 days
(61 Reviews)
6.3
sy3d

Consider it done with 100% accuracy, please check pm for further details .. thx

$250 USD in 1 day
(105 Reviews)
6.2
slavisatosic

Hello, I am offering you to make this extract using Excel VBA script. Please see private message for details.

$80 USD in 2 days
(106 Reviews)
6.0
greggfletcher

Hello, please refer to your INBOX. Best Regards.

$100 USD in 0 days
(37 Reviews)
5.9
techservice

Please check the message box.

$35 USD in 1 day
(83 Reviews)
5.9
mantislin

Hi sir, please check PM, thx Kimi.

$248 USD in 5 days
(47 Reviews)
5.7
deepbluetech

I can take on the job. Unable to provide sample since the Dropbox link has been disabled. Let me know.

$200 USD in 1 day
(140 Reviews)
5.5
nagybatonyi

Such jobs are my daily practice. Your file can't be downloaded because the site is disabled due to large traffic. If you send me a sample extract I'll make a live pilot conversion for you. My bid includes also the macr More

$90 USD in 2 days
(38 Reviews)
5.3
Rahul2012

HI eliotjacobs, Could you please check your personal message?

$150 USD in 2 days
(18 Reviews)
5.3
vsolcorp

Hello eliotjacobs, We are professional & skilled team with experienced in this track. I would very much like to work with you on this project and request that you contact me through www.freelancer.com to discuss s More

$255 USD in 3 days
(20 Reviews)
5.2
tmoi06

Sir/Madam, It is my pleasure to be able to bid on your project. I would like to give my fullest and maximum contribution towards the success of this project. Anticipating your favorable reply. For further More

$30 USD in 2 days
(224 Reviews)
4.7
kulhanekd

I tried to open the file and it was temp. disabled due to high traffic. I have been an administrative assistant for 15 years. I know excel up to expert. I am sure I can create the spreadsheet you need. Donna

$150 USD in 2 days
(11 Reviews)
4.4
nutanbhosale

Hi, I can do this in the next few hours. Please check PM.

$70 USD in 1 day
(21 Reviews)
4.2
mfumia

Greetings, I am very interested in your project. I have many years of database and Windows VBA development experience. I am available to begin work on your project immediately. I am downloading your zip file an More

$125 USD in 1 day
(29 Reviews)
4.1
katepesic

Hi, I can do this job, please contact me

$250 USD in 3 days
(22 Reviews)
4.1
JackBradford

I can so this using VBA in about 1 hour.

$40 USD in 1 day
(8 Reviews)
3.6
jiashahood

Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks

$90 USD in 5 days
(12 Reviews)
3.5
vickkey7

I am ready to start this project... thanks

$51 USD in 1 day
(7 Reviews)
3.1