Need a tool or solution to filtering a 22GB JSON file


I need someone that can create a tool or help me to set up a solution to let me filter my JSON database.

I have attached a sample of the file.

I will work with 3 columns from this database; Keyword, URL and Title.

I need to be able to filtering with specific parameter like;

Example of queries:

1. Show only rows that the URL include "coffee" in URL.

2. Show only rows that the domain name include "coffee" (For this query, it will research in the URL column but only in the domain name, not the entire URL. ([login to view URL], in this example, the query should look for "[login to view URL]" only and not "[login to view URL]".

3. Show only rows that the title include "coffee".

4. Show only rows that the title and full URL include "coffee".

5. Show only rows that the title and domain include "coffee".

Once I have the results.. I want to be able to export it in excel format.

Kemahiran: PHP, Pengaturcaraan C#, JSON, MySQL, Pembangunan Perisian

Lihat lagi: filtering an array of json objects by multiple properties, filter json object by key, json filter with multiple values, filter data from json object in jquery, how to filter data from json file, json filter online, json filter, json filter example javascript, need textbook solution, jquery remote json file, need pull data csv delimited text file, extjs json file, extjs datagrid blank local json file, jquery select load json file, jquery json file, create json file html, make json file, saving html data json file, solution counting words text file finding frequency write test mips assembly language program, create table json file

Tentang Majikan:
( 38 ulasan ) Sabrevois, Canada

ID Projek: #25160370

Dianugerahkan kepada:


Hi, The solution is to import the JSON file first to a database, and then perform your queries on the database, and export from the results. I can develop a Windows application, with a local MySQL database , to do t Lagi

$200 USD dalam 7 hari
(40 Ulasan)

13 pekerja bebas membida secara purata $183 untuk pekerjaan ini


i'm checking the file you have attached in the project description. i think i can have a solution for your requirement about filtering. do you want to filter in database or a json file?

$140 USD dalam 3 hari
(52 Ulasan)

Hello! I already review your json sample file, I can develop a desktop app in C# to extract the json rows applying the filters to the domain only or the full url, Please contact me.

$250 USD dalam 7 hari
(2 Ulasan)

Hello there, I offer MS WIndows based tools to process JSON , XML and other data format-based (text based) databases. Since your database is 22 GB large, it wouldn't be wise to store it all in memory, and hence would Lagi

$500 USD dalam 7 hari
(11 Ulasan)

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Willing and looking forward to working with you. Thank yo Lagi

$140 USD dalam 3 hari
(33 Ulasan)

-- JSON Expert --------------- I have solution for you ---- i can extract as you describe from the sample JSON file ---can you come on CHAT ---thanks

$195 USD dalam 3 hari
(24 Ulasan)

Hi there, Yes sure. Let me handle your task in Python. Will deliver standalone GUI too. And yes file size won't matter. Exp in data processing + regex. Will glad to work on it. Best regards, Ishaq

$100 USD dalam 3 hari
(14 Ulasan)

I have experienced in Python, building Machine Learning models, Deep learning for computer vision and Natural language processing are some of my strong suites with a PhD in AI/ML. Image processing, Object detection and Lagi

$200 USD dalam 2 hari
(6 Ulasan)

I have more than 15 years experience of Delphi Developer. I started with Delphi 5 and working with XE10.3 Rio now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big files, Lagi

$120 USD dalam 7 hari
(3 Ulasan)

Hello, I am pleasure with your job for Need a tool or solution to filtering a 22GB JSON file. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do h Lagi

$140 USD dalam 7 hari
(2 Ulasan)

Hi! I am skilled Swift computer programmer with skills including Software Development, JSON, PHP, MySQL and C# Programming. Please send a message to discuss more regarding this project. Thank you

$155 USD dalam 7 hari
(2 Ulasan)

Hi There, Hope you doing well. I have understood the requirement and can provide you a code with minimal dependency. At the end of the transformation of the job you will be getting an excel file with the desired resu Lagi

$100 USD dalam 7 hari
(1 Ulasan)

I have Hands on experience in software development and in developing tools. I have good experience in C# web and windows application. I am fit for this work.

$140 USD dalam 7 hari
(0 Ulasan)