Search text in JSON array in c#

Question

I'm implementing simple search engine.all the data saved as a JSON in text file. My implementing scenario is,If I search word like 'rock' method should return result as list of tag Id's containing 'rock' value.I have been looking for sample codes but in every exsample they search by tag like track_id" but I need search by value. This is my sample JSON array ..

enter image description here

Test word : rock expected result : 991335,991336,991337

Amel · Accepted Answer · 2015-11-19 13:06:49Z

2

I suggest to use a JSON library, like Json.net.

If you can allow to read the whole file, its super-easy with linq.

class TrackElement {
    public Track Track {get;set;}
}
class Track {
    public string track_id{get;set;}
    public string track_name{get;set;}
    public string track_category{get;set;}
}

Read file, deserialize and search:

var data = File.ReadAlltext("path/to/your/file.txt");
List<TrackElement> database = JsonConvert.DeserializeObject<List<TrackElement>>(data);

var results = database.Where(i=>i.Track.track_category.ToLower().Contains("rock")).Select(t=>t.Track.track_id);

If the database is real large, you should not read the whole stuff into memory, in this case you can use streamed parsing (token-by-token), reading the file directly. For this, you can use the JsonReader class from Json.net lib. (http://www.newtonsoft.com/json/help/html/T_Newtonsoft_Json_JsonReader.htm)

edited Nov 19, 2015 at 13:06

Amel

7086 silver badges17 bronze badges

answered Nov 19, 2015 at 12:43

Gergely Hamos

4114 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

isanka thalagala Over a year ago

Thanx for your quick response and your answer is correct but it's difficult to adjust to my scenario..Because you used to search only in track_category tag. var results = database.Where(i=>i.Track.track_category.ToLower().Contains("rock")).Select(t=>t.Track.track_id); but in my case I can't define any fix tag. 'Rock' can be saved as track name,track category or artist name.. I need return track id list which are contain 'Rock' in any tag..

Gergely Hamos Over a year ago

Then the only way to solve is to use a more complex search expression, like: var results = database.Where(i=>i.Track.track_category.ToLower().Contains("rock") || i.Track.track_id.ToLower().Contains("rock") || i.Track.track_name.ToLower().Contains("rock") ).Select(t=>t.Track.track_id); You can make it much more clear if you write a helper method for the search expression.

Jannick Breunis Over a year ago

Great, easy and fast solution! There's a typo in the code, ReadAllText with capital T.

Collectives™ on Stack Overflow

Search text in JSON array in c#

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related