D
D
Daff02022-02-08 03:41:44
Parsing
Daff0, 2022-02-08 03:41:44

JSON parser in PHP or Python?

Hello dear gurus.
A question. I need a parser, but I'm not smart enough to write.
There is an example page: https://m.banggood.com/index.php?com=slash&t=getSl... , 3418001, 3418014, 3418032 and so on. (there are about 21 such links in 7 days, you need to parse them at a time)
You need to parse the lines "email": "xxx" and also exclude the lines "Slashed \u20b40.00"
And write this into an excel spreadsheet. I have a parser in Python, but everything is very dreary there. Tell me how to do it better or give me some information.

And even easier is the question of how to parse a pure email from a page with a record in excel

. And what is all this for?:
There is a table with participants and their mails, such a database.
And there are links where these mails took part.
You need to parse them, compare them with the database and see who took part in the event how many times in 7 days.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
H
HemulGM, 2022-02-08
@HemulGM

JSON does not need to be parsed, it is a standardized format that has libraries in almost every language to read. You just need to read. This is the most elementary thing that does not require any mind at all.

R
rPman, 2022-02-08
@rPman

php has a built-in function json_decode
returns a ready object (or an array, depending on the parameters) in memory
if excel is needed without registration just a table, then try to save in csv format, it is text and oak (on php - fputcsv ) otherwise work with open document odt or Microsoft's xlsx (it is similar) which is in fact a zip archive with text xml files that can be generated stupidly by writing to a text file according to a template

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question