Closed

Parse text file in database table

hi ,

I need help to write script that can parse and structure 2 text files into database table.

This files are export from a pdf book with articles and follow a pattern that can be used for parsing the file.

The content is written cyrillic characters , so need someone that can at least understand character set.

Due to content complexity , I'm fine with just getting to columns of data. Article_title and article_content.
Article_tittle column:
1. Always starts with a word and/or sentence with ALL CAPITAL Letters:
АТАНАС
МАРКОВСКИ
ДОБАР И ПОДОБАР СЕ ЗАЕДНО
2. Always ends with " - " character and its followed by article_content
3. May include lowercase word after comma " , " when article is about some person
МАРКОВ, Марко
ТОДОРОВСКИ, Адам

Article_content
1. All text including the title until the beginning of the new article that starts with ALL CAPS


There are few other cases , but this would be the base

Skills: MySQL, Perl, PHP, Python, Regular Expressions

See more: parse linux file database, parse txt file database table, java code parse text file database, parse text file java, text file database java, import text file database using net, java parse text file, import text file sql table, linux parse text file database, parse text file php, php parse text file, parse text file, writing java app parse text file, dts import text file database, import text file existing table sql server 2005, java code parse text file, java parse text file database, parse text file java database, parse text file java mysql database, parse text file content database ruby

About the Employer:
( 0 reviews ) Ormond Beach, United States

Project ID: #17726414

47 freelancers are bidding on average $154 for this job

maxsmith8

Hello there, I am interested and ready to start, lets discuss with details. Please visit our profile and see our project reviews https://www.freelancer.com/u/maxsmith8.html looking forward to hear from you More

$100 USD in 1 day
(215 Reviews)
8.0
WebInfoSolutions

Respected Sir/Madam, I saw the txt and pdf file. Can you please tell the field names in database? Can u please tell if this is mysql database? Pankaj Garg UserName: WebInfoSolutions Profile Page: https://www. More

$250 USD in 3 days
(209 Reviews)
7.9
extreamcode

HI There, I can assist you extract/ parse files and then add them to DB. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You can c More

$155 USD in 3 days
(72 Reviews)
7.5
liangjongai

Hello, sir! I'm interesting your project very well. I am mastering MySQL and text parsing. And also I have many experience and good skill about web development. so please give me a chance to work with you. Lets c More

$150 USD in 3 days
(245 Reviews)
7.6
coolguyinus2004

First the whole words are in russian i guess. To do PHP russian code REGEX is complex and time consuming. I still need to discuss alot as pdf and text sample file dont have exact same content though. Discuss with me vi More

$555 USD in 3 days
(349 Reviews)
7.6
elbruninh

Hi i have the job done check here please [login to view URL] regards

$60 USD in 1 day
(84 Reviews)
6.3
restinpc

Hello Sir! I'm ready to take part in this project if you ok with my bid. Expert in C++, PHP, MySQL, JavaScript, jQuery, CSS3, HTML5, Java, A-Frame, Node.js, [login to view URL], Java, MQL, CGI, Google API, XML, JSON, SOAP, OAut More

$200 USD in 3 days
(20 Reviews)
6.3
ARKSolution2015

Sir, I have gone through your project description and am looking to provide my service for parsing text files into database. For more than 7 years I’ve worked in this field. web projects [login to view URL] https More

$200 USD in 3 days
(133 Reviews)
6.4
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and re More

$250 USD in 5 days
(222 Reviews)
6.6
glennwilkins

sir pm me i will help you i have same project about cyrillic char. and im php expert i can finish this today

$50 USD in 0 days
(148 Reviews)
6.2
ThanassisKalv

I can parse this with Python and export to mysql or sqlite db (or mongo) I also understand cyrillic as I have studied russian a little bit. But what are your specification about the DB schema?

$155 USD in 3 days
(93 Reviews)
5.9
sypsoo

I need help to write script that can parse and structure 2 text files into database table. This files are export from a pdf book with articles and follow a pattern that can be used for parsing the file. The conte More

$140 USD in 5 days
(52 Reviews)
6.3
DiegoPHP

Hi, I can parse your txt files and export the rows to a mysql database. Please, can we chat and see more details?

$200 USD in 10 days
(46 Reviews)
6.3
$111 USD in 2 days
(16 Reviews)
5.2
supersuntech

I am a hard worker with fast learning capability. A results-driven, customer-focused, diligent and analytical Software Engineer who strive for self-development. Strong in design and integration problem solving skills. More

$277 USD in 2 days
(17 Reviews)
5.0
bianyunzhi95

Hey, I hope to see you in chat. Though I am new to freelancer.com I am an experienced python developer with full-stack knowledge and career. I'm sure I can do this perfectly. Thanks for your kind attention.

$120 USD in 1 day
(19 Reviews)
4.9
dinhfreedom

Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Python & PHP Programming. I'm really confident about your project, and very eager to join your project. If we have More

$155 USD in 3 days
(22 Reviews)
5.3
quickapp100

Hi we are a software development company from india in past 8 years career me & my Team developed Multiple projects for global industries , we develop applications according to client requirements . we developed More

$155 USD in 3 days
(12 Reviews)
4.6
lightingdavid

Hello. I have rich experiences in MySQL, Perl, PHP, Python, Regular Expressions. I have read your project description carefully and i can do it perfectly. Contact me please. Thanks.

$140 USD in 3 days
(24 Reviews)
4.7
tausy

Hi, I am a software developer with over 5 years of experience developing and deploying various data-centric applications using SQL, PL/SQL and other similar tools and technologies. I have worked on numerous databases More

$200 USD in 3 days
(30 Reviews)
4.7