Select two fields out of three fields from Json data using Linq.js

Question

I need to select two fields out of three fields from Json data using Linq.js

Required output should be

[{ "A": -27, C: "country 1" } , { "A": 28 , C: "country 2"} ]

using "linq.js" from following path: [ https://raw.github.com/gist/1175460/fb7404d46cab20e31601740ab8b35d99a584f941/linq.js ]

Sample data

var Data = [{ "A": -27, "B": -39, C: "country 1" }, { "A": 28, "B": 0 , C: "country 2"}]

var filter = "  x =>    x['A'], x['C']  ";
var findItem = Enumerable.From(Data)
.Select(filter)
.ToArray();

console.log(findItem);

code at JsFiddle : http://jsfiddle.net/gLXNw/9/

Jeff Mercado · Accepted Answer · 2013-02-28 08:20:43Z

7

Your "lambda" function must return a valid java object.

Your query should be more like this:

var query = Enumerable.From(data)
    .Select("x => { A: x['A'], X: x['C'] }") // object initializer
    .ToArray();

answered Feb 28, 2013 at 8:20

Jeff Mercado

136k34 gold badges268 silver badges282 bronze badges

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

2 Comments

irfan Munir Over a year ago

and thanks but in .net linq i used to select fields using cards.Select(c => new { c.Type, c.Limit }).ToList() ;

irfan Munir Over a year ago

I change the select clause as follows cz i am creating select using run time values. "x => { \"A"\: x['A'], \"C"\: x['C'] }"

Sergii · Accepted Answer · 2013-02-28 08:34:29Z

7

You can use function in result selector instead of lambda (if lambda expression was used not for political reasons :))

var findItem = Enumerable.From(Data)
.Select(function(x){
    return {
        'A': x['A'], 
        'X': x['C']
    };
}).ToArray();

answered Feb 28, 2013 at 8:34

Sergii

1,33010 silver badges10 bronze badges

1 Comment

Kashif Hanif Over a year ago

it works if property contain space e.g "Hair Cut" where x.Hair Cut will not work, saved my time, thanks

Collectives™ on Stack Overflow

Select two fields out of three fields from Json data using Linq.js

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related