1
Vote

filter column name with space & special characters

description

var arrTrades = [
    {
      "USER NAME": "A",
      "FLAT NO": "4",
      "SELL/BUY": "S"
    },
    {
       "USER NAME": "B",
      "FLAT NO": "3",
      "SELL/BUY": "S"
    },
  {
       "USER NAME": "C",
      "FLAT NO": "",
      "SELL/BUY": "B"
   }]
I would like to filter on FLAT NO column and also group by "User Name" & "Sell/BUY" column.
Tried below codes but no success
var jsonData = Enumerable.From(arrTrades).Where("$.[FLAT NO]!=''"); //
    var GroupByContractData = Enumerable.From(modifiedJsonData).GroupBy("{ PL1: $.[User Name] , PL2: $.[SELL/BUY] }").ToArray();
Any help would be appreciated.

comments