Fermé

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

Compétences : MySQL, Perl, PHP, Python, Expressions régulières

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Ormond Beach, United States

Nº du projet : #17726414

44 freelance font une offre moyenne de $156 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(241 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(214 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(263 Commentaires)
7.8
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(350 Commentaires)
7.6
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(59 Commentaires)
6.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(74 Commentaires)
6.6
elbruninh

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
6.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(147 Commentaires)
6.6
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(250 Commentaires)
6.7
glennwilkins

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(174 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(22 Commentaires)
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?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(50 Commentaires)
6.4
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?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(96 Commentaires)
6.0
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(74 Commentaires)
6.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(25 Commentaires)
5.5
kenb080

Hello, I have read your project details carefully and would like to discuss my skills and plans with you. I am an c# expert and have been developing and experimenting with it for 7 years. Great things come fro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
5.6
RobustTechServ

Hi there! My name is Orestes and I am a Software Engineer with specialty in Java/Spring. I represent a team of engineers (so our 'language' stack is actually quite big: Java, C#, Javascript, Python among others)that h Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(3 Commentaires)
5.4
Nidhijain123

Hi, My name is Nidhi. I have very sound experience in scraping and have my own tool for scraping data from website. I can even write a new script to suit your requirements.I have read the details and I am ready to s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
5.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(27 Commentaires)
5.6