{"id":5064,"date":"2020-02-15T07:56:54","date_gmt":"2020-02-15T06:56:54","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=5064"},"modified":"2020-02-16T12:08:03","modified_gmt":"2020-02-16T11:08:03","slug":"convert-some-data-into-another-format","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/convert-some-data-into-another-format\/","title":{"rendered":"Convert some data into another format"},"content":{"rendered":"

The problem to solve is this:<\/p>\n

I got some data like this in a text file<\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/div>\n<\/td>\n
\n
\n
0001___data___are___important<\/span><\/div>\n
0002___data___are___important<\/span><\/div>\n
0003___data___are___important<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

 <\/p>\n

I want the data to be like this<\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/div>\n<\/td>\n
\n
\n
0001<\/span><\/div>\n
data<\/span><\/div>\n
are<\/span><\/div>\n
important<\/span><\/div>\n
<\/div>\n
0002<\/span><\/div>\n
data<\/span><\/div>\n
are<\/span><\/div>\n
important<\/span><\/div>\n
<\/div>\n
0003<\/span><\/div>\n
data<\/span><\/div>\n
are<\/span><\/div>\n
important<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

 <\/p>\n

import tkinter as tk\r\nfrom tkinter import filedialog\r\nimport os\r\n\r\n\r\nroot = tk.Tk()\r\nroot.withdraw()\r\n\r\nmy_filetypes = [('text files', '.linee'), ('all files', '.*')]\r\nanswer = filedialog.askopenfilename(parent=root,\r\n                                    initialdir=os.getcwd(),\r\n                                    title=\"Please select a file:\",\r\n                                    filetypes=my_filetypes)\r\n\r\n\r\nwith open(answer, \"r\", encoding=\"utf-8\") as file:\r\n    file = file.read()\r\nprint(file)\r\n\r\n\r\ntext = file.replace(\"\\n\", \"\\n\\n\")\r\n\r\ntext = text.replace(\"___\", \"\\n\")\r\n\r\n\r\nwith open(answer[:-6] + \".txt\", \"w\", encoding=\"utf-8\") as file:\r\n    file.write(text)\r\n\r\ntextfile = answer[:-6] + \".txt\"\r\nos.startfile(textfile)\r\n\r\nroot.mainloop()<\/pre>\n
 <\/p>\n