regex - How to return a result from JSON with case insensitive search using javascript? - Stack Overflow

admin管理员组

文章数量:1399225

My JSON contains 'products' that each have multiple values (name, manufacturer etc.)

I have the following code that allows me to pull 'products' from my JSON based on a search result acquired from a query string. It works fine, but only if the search entry is formatted exactly how it is written in the string.

How can I allow case insensitive searches yield the desired result (and ideally, partial searches)?

I believe that regular expressions are the way to go, but I've exhausted my knowledge and can't seem to get anywhere with it.

I tried to put together a fiddle but couldn't get a proper demo working, so instead I've tried to consolidate the code and ment it for clarity. Any help would be greatly appreciated :)

Parse the JSON:

var prodobjects = JSON.parse(prods);

Code to get products based on specific value:

function getData(array, type, val) {
  return array.filter(function (el) { 
    return el[type] === val;
  });
}

Code to retrieve query string:

function gup( name ){
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");  
var regexS = "[\\?&]"+name+"=([^&#]*)";  
var regex = new RegExp( regexS );  
var results = regex.exec( window.location.href ); 
 if( results == null )    return "";  
else    return results[1];}

Section of query string I want to use:

var prodresult = gup( 'search' );   

Remove plusses and replace with spaces:

var removeplus = prodresult.replace(/\+/g, ' ');

Compile list of products with their 'Prodname' matching the 'search' query:

var searchname = getData(prodobjects.products, 'Prodname', removeplus);

And as requested here is a sample of the JSON. It's still in development so the null values etc. are currently being worked out (it's received through an api). This is just one of the products, but the actual string contains many in the same format (but within "products"):

var prods = JSON.stringify({"products": [
    {
        "Prodname": null,
        "Oem": "Example OEM",
        "Snippet": "Example Snippet",
        "Linkto": "www.linkhere",
        "Imagesource": "image.png",
        "Category": "Category",
        "Tagline": "Tagline goes here",
        "Longdescription": [
            {
                "Paragraph": "<p>First description of the paragraph</p>"
            },
            null,
            null,
            null
        ],
        "Features": null,
        "Company": false,
        "Subscribed": false,
        "Tariffs": [
            {
                "Tarname": "Tariff one",
                "Tarpaysched": "Monthly per User",
                "Tarcost": "£1"
            },
            null,
            null,
            null,
            null,
            null
        ],
        "Extratariffs": null
    }
]
});

---UPDATE---

I managed to get it working to support partial searches and case insensitivity with the following:

function getData(array, type, val) {
  return array.filter(function (el) {
      if (el[type]!=null && val!=null) {
          var seeker = val.toLowerCase();
          var rooted = el[type].toLowerCase();
          var boxfresh = rooted.indexOf(seeker);
          if (boxfresh!=-1) {
              return rooted
          }
      }
  });
}

My JSON contains 'products' that each have multiple values (name, manufacturer etc.)

I have the following code that allows me to pull 'products' from my JSON based on a search result acquired from a query string. It works fine, but only if the search entry is formatted exactly how it is written in the string.

How can I allow case insensitive searches yield the desired result (and ideally, partial searches)?

I believe that regular expressions are the way to go, but I've exhausted my knowledge and can't seem to get anywhere with it.

I tried to put together a fiddle but couldn't get a proper demo working, so instead I've tried to consolidate the code and ment it for clarity. Any help would be greatly appreciated :)

Parse the JSON:

var prodobjects = JSON.parse(prods);

Code to get products based on specific value:

function getData(array, type, val) {
  return array.filter(function (el) { 
    return el[type] === val;
  });
}

Code to retrieve query string:

function gup( name ){
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");  
var regexS = "[\\?&]"+name+"=([^&#]*)";  
var regex = new RegExp( regexS );  
var results = regex.exec( window.location.href ); 
 if( results == null )    return "";  
else    return results[1];}

Section of query string I want to use:

var prodresult = gup( 'search' );   

Remove plusses and replace with spaces:

var removeplus = prodresult.replace(/\+/g, ' ');

Compile list of products with their 'Prodname' matching the 'search' query:

var searchname = getData(prodobjects.products, 'Prodname', removeplus);

And as requested here is a sample of the JSON. It's still in development so the null values etc. are currently being worked out (it's received through an api). This is just one of the products, but the actual string contains many in the same format (but within "products"):

var prods = JSON.stringify({"products": [
    {
        "Prodname": null,
        "Oem": "Example OEM",
        "Snippet": "Example Snippet",
        "Linkto": "www.linkhere.",
        "Imagesource": "image.png",
        "Category": "Category",
        "Tagline": "Tagline goes here",
        "Longdescription": [
            {
                "Paragraph": "<p>First description of the paragraph</p>"
            },
            null,
            null,
            null
        ],
        "Features": null,
        "Company": false,
        "Subscribed": false,
        "Tariffs": [
            {
                "Tarname": "Tariff one",
                "Tarpaysched": "Monthly per User",
                "Tarcost": "£1"
            },
            null,
            null,
            null,
            null,
            null
        ],
        "Extratariffs": null
    }
]
});

---UPDATE---

I managed to get it working to support partial searches and case insensitivity with the following:

function getData(array, type, val) {
  return array.filter(function (el) {
      if (el[type]!=null && val!=null) {
          var seeker = val.toLowerCase();
          var rooted = el[type].toLowerCase();
          var boxfresh = rooted.indexOf(seeker);
          if (boxfresh!=-1) {
              return rooted
          }
      }
  });
}

• javascript
• regex
• json
• search
• case-insensitive

Share Improve this question Follow edited Feb 20, 2014 at 20:51 Visiophobia asked Feb 20, 2014 at 18:01 VisiophobiaVisiophobia 15311 gold badge33 silver badges88 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 5

You can convert two strings to lowercase (or uppercase) to make the parison case-insensitive.

function getData(array, type, val) {
  return array.filter(function (el) { 
    return el[type].toLowerCase() === val.toLowerCase();
  });
}

For better searching, you might want to look into fuzzy parison, which is "a search against data to determine likely mispellings and approximate string matching".

本文标签： regexHow to return a result from JSON with case insensitive search using javascriptStack Overflow