Put Questions from TXT File into an Excel Spreadsheet

I need to extract the questions and answers from a PDF book (I converted it to TXT as you find this easier to manipulate the text from) and place the questions with their corresponding answers in an excel spreadsheet.

I attached an excel spreadsheet to illustrate how the information needs to be input into excel. I did the first 20 questions to illustrate how it should be done. Please note that the answers are in a section after the questions. Therefore, you must make sure to have each answer correspond with the correct question. You must also make sure to properly categorize each question by subject (there are six subjects – Constitutional Law; Contracts; Criminal Law; Evidence; Real Property; and Torts). There are an estimated 1,293 questions.

The following fields in Excel must be completed for each of the 1,293 questions:

QNum – the question number from the PDF book for that question

Subject – there are six subjects – Constitutional Law; Contracts; Criminal Law; Evidence; Real Property; and Torts. The subject is at the beginning of each section (except for the PART TWO INTERMEDIATE QUESTIONS – these 200 questions do not have a defined subject)

Question – this is the question. When multiple questions use the same fact pattern, you must put that common fact pattern for each of those questions. For example, for Questions 2-5 of the first section of the book, they are all based on the same fact pattern. You know this because the questions will start with language such as:

Questions 2-5 are based on the following fact situation

Look at the sample sheet Freelancer Multiple Choice Question [url removed, login to view] to see how these are handled. Basically, The common fact pattern is repeated for each question and the question number is arranged appropriately.

answerA – this is the (A) answer choice text (without the (A))

answerB – this is the (B) answer choice text (without the (B))

answerC – this is the (C) answer choice text (without the (C))

answerD – this is the (D) answer choice text (without the (D))

explanation – this is the answer explanation for that question (usually found at the end of the section).

I don’t care about typos that exist (due to the conversion of the text from PDF to TXT). However, you must make sure that the Questions are complete, that the answer choices for each question correspond to that question, not another question, and that the answer explanation for that question corresponds with that question.

This should be fairly easy for someone with scripting/macro experience.

I will pay $30 for this project and it must be done within 3 days.

I suggest you send me a text file for the first 100 questions to demonstrate that you can do this correctly.

No escrow. Payment only after 24 hours of completion of project.

If there are any questions, please PM me.

Beceriler: Yazı Kopyalama, Veri Girişi, Veri İşleme, Excel, Word

Daha fazlasını gör: suggest someone on freelancer, subjects freelancer, someone to illustrate a book for me, scripting freelancer, questions to, questions part 2, questions about me, payment into escrow, make data entry easier, intermediate excel, i need an excel freelancer, how to find someone to illustrate a book, how do they pay at freelancer, freelancer start from $5, freelancer questions and answers, freelancer questions, freelancer make excel, freelancer how to extract, freelancer from beginning, freelancer for excel macro, freelancer excel spreadsheet, freelancer answers, find it contracts, escrow contracts, contracts freelancer

İşveren Hakkında:
( 22 değerlendirme ) Monroe, United States

Proje NO: #4443926



Such jobs are my daily practice. No doubt I can do this job, however I can't send you the first 100 questions processed before having been awarded the project because it would require to write and test the whole macro. Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 40%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(39 Değerlendirme)

Bu iş için 20 freelancer ortalamada $44 teklif veriyor


Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

in %bids___i_period_sub_35% gün içinde64%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(61 Değerlendirme)

Hi, I am highly interested and the private message shows what I can do to help you along the way. Please check. Thank you very much. Best! Kalpana

in %bids___i_period_sub_35% gün içinde37%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)

Hello superxl2007, 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 specif Daha Fazla

in %bids___i_period_sub_35% gün içinde33%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)

I can take on the job. Let me know.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)

HI, I can do it. I'm a programmer for years and very familiar with VBA for excel. If you need the vba code for this project, i only need 20$ additional. Best regards, Cuong NH

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)

sir please see pm and reply.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)

I can get this done quickly using Excel VBA to automate the process. Let me know if I can help.

in %bids___i_period_sub_35% gün içinde78%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Hello, I can help you by creating java program for this, will be really easy to use program, thanks

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Let have a good start, I CAN DO this job with vary accuracy.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)

Hi, Please check sample. I've 10 year experience of data entry and typing work. Typing speed 60 WPM. Excellent knowledge of MS Excel 2007, 2010, Internet Research and Web Scraping. Please check PM for m Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hi, I can do this easily and fastly

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

HI We will give you Excel Template with Macro Button/VBA to do this for all futur needs Recently completed a similar project,Please see PMB

in %bids___i_period_sub_35% gün içinde53%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Looking forward to work on your project.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Hello AB, I am specialist in VBA. Optimizing scripts is my job and my hobby. Hiring me is the right decision. :) You will be satisfied with the results.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

Hi, I would like to do it for you if you let me. I believe that i'm very good at excel.

in %bids___i_period_sub_35% gün içinde71%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hello I'm an engineer so I should be used to this kind of work although I'm a newbie on this site waiting for my first opportunity. Be sure that I can do it with no errors. The quality is a priority for me.

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am expert in data entry. I am ready to do this work . Will complete it within 24 hours. I am ready to do this at 30$.

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, i'm interested in this project. started of with your sample work.

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

hi, I will make it done for you accurately.

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)