Automating the JSON Creation Process

Question

Automation

Hello. In general, I have the following set of text.

Petrov Vasily Ivanovich
Neurologist
[phone]
[email protected]
Candidate of Medical Sciences, Physician of the 7th Department of Neurooncology

And I have 200 of these sets. How to automate the process of turning these blocks into this:

{
"name": "Petrov Vasily Ivanovich",
"profession": "Neurologist",
"description": "Candidate of Medical Sciences, Doctor of the 7th Neuro-Oncological Department",
"phone": "[phone]",
" email":"[email protected]"
},

Thanks for the help!

Answer 1

Umm, well, just parse line by line and convert to JSON, what's the difficulty?

Answer 2

Here is an example if there are empty fields:

$str = " Петров Василий Иванович

[phone]
[email protected]
Кандидат медицинских наук, врач 7 Нейроонкологического отделения
";
$pattern = '/(.*)\n(.*)\n(.*)\n(.*)\n(.*)\n/';
$replacement = '{
"name":"$1",
"profession":"$2",
"description":"$5",
"phone":"$3",
"email":"$4"}';

echo preg_replace($pattern, $replacement, $str);

Answer 3

Here is a regex in php as an example:

$str = "
Петров Василий Иванович
Невролог 
[phone]
[email protected]
Кандидат медицинских наук, врач 7 Нейроонкологического отделения
";
$pattern = '/(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n/';
$replacement = '{
"name":"$1",
"profession":"$2",
"description":"$5",
"phone":"$3",
"email":"$4"}';

echo preg_replace($pattern, $replacement, $str);

Answer 4

In what language is the solution even needed? Will this solution need to be integrated somewhere or will it be used manually?