VBA - optimize runtime for hiding columns

I have a worksheet with a table of 50 years, starting from 2017 to 2066. This macro is making a print area for the first 10 years, with the tenth year being a user input and hiding any other columns. We would remove the 10th consecutive year (2026) a...
more »

2017-03-24 23:03 (1) Answers

Giving result from random query in search box

This following script works as long as the keyword/user's query contains single word. When I type 2 words, such as; 'honda brio', it shows as I wish. But when I type randomly, such as; 'brio honda'. It does not show anything. How can I enable the se...
more »

2017-03-21 14:03 (0) Answers

Look for a word in a set of cells

I am trying to create a cell that gives a pass/fail result based on the contents of D11:D15. If even one of the cells in that range have the value of "FAIL", I want the cell above (that the formula is going into) to read "FAILED". If they are all "PA...
more »

2017-03-20 15:03 (1) Answers

Search emails including attachments stored in HDFS

I need to search the text content of a couple of TB of email files (.eml, .msg) including their attachments (mainly office documents, .xlsx, .docx, .pptx, .pdf) stored on a Hadoop distributed File System (or probably a data store like HBase) for a bu...
more »

2017-03-10 10:03 (0) Answers

Python: How to return a list of connected nodes

I have a set of nodes (stored as nodes = np.array([[x1,y1],[x2,y2],etc]])) and elements connected the nodes. Each element is an array of the two node indices. So [0,3] is an element connecting nodes 0 and 3. How would I return a list of all node i...
more »

2017-03-08 17:03 (4) Answers

Tips to Build search algorithm in Laravel

I have a website made in Laravel 5.2, and I need to implement a search box, I know what it basically the process involves (make petition to controller, find and then answer with json, etc). So, before do that I really need to know some tips, what a...
more »

2017-03-07 20:03 (2) Answers

Score aggregation results in ElasticSearch

I created a type named test that consists of a prices nested field. Each document can consist of several prices and each price consists of price and date: ... "prices":[{ "date" : "2017-02-08T16:04:20.424Z", "price" : 120 }, { ...
more »

2017-03-07 01:03 (0) Answers

How to get url of Nth google search result?

I saw this question but there is no answer. So, I must ask again: is there any way to get second, third... url of Google search results? This example for I'm feeling lucky is what I need, but for other results too. Thanks. ...
more »

2017-03-06 01:03 (0) Answers

Change custom taxonomy url in tag cloud wordpress

I have a search form which allows users to select cities to display results in a customized search page. On the other hand I have created a page for each Region (Europe, Asia, etc) and in each page I have a "tag cloud"(with categories instead tags) ...
more »

2017-03-03 15:03 (0) Answers

Finding MIN MAX pairs from array

Given a sorted array of N integers, I need to find to all pairs with different indexes(i!=j). I need the maximum (a[j]+a[i]-1) and minimum (a[j]-a[i]+1) out of all pairs with (j>i). Numbers aren't unique but their pairing is allowed. Numbers can't...
more »

2017-02-12 05:02 (1) Answers

Date Range Search in Lucene 4.0

I have a situation where I need to search data between range of two dates(including lower and upper values) in LUCENE 4.0. I have a field in the indexes which has a String value in the format "YYYY-MM-DD HH:MM:SS". Now I need to make a search between...
more »

2017-02-10 17:02 (0) Answers

URL Result After Mutiple Drop Down Select

I have multiple drop down boxes and depending on which drop downs are selected I would like to return a URL that is not related to the selections themselves. I can get it to work for one dropdown but I do not know how best to go about creating a uni...
more »

2017-02-08 20:02 (0) Answers

Searching for a name in PHP

How do you search for a name, or something like a keyword and expected a many results? Like, when you search Mark, You're expecting to have like this: Mark Zuckerberg Mark Hamil Mark Fischbach ... But when I do the query, it only display one for me...
more »

2017-01-26 12:01 (2) Answers

Haskell create a Phonebook as a list of tuples

I need to create a phonebook as a list of tuples: type Phonebook :: [(String,String)] As you can see in the code, the first element should represent the name and the second element the number. So the result of Main> phonebookone = insert "Dad"...
more »

2017-01-19 19:01 (2) Answers

Search URL on the new LinkedIn UI

Looks like LinkedIn has a new UI and seems to be slowly rolling out to everyone. We have a LinkedIn button on our site that looks up a prospect by their name and company and searches LI. Currently, this works for the "oldLinkedIn" but for me, I'm som...
more »

2017-01-19 01:01 (0) Answers

Laravel 5.3 filter search data in API

I'm implementing an API for front end and mobile apps now i'm working on search function where a user may type column name or any data i should be able to provide the data they request in a JSON format so for i did this in my controller public fu...
more »

2017-01-14 09:01 (1) Answers

Python Google Search

I try to search for a word in google with python. Then I try to extract it into a list and print the list. But now I've got this problem: class search: def __init__(self, search): page = requests.get("http://www.google.de/search?q="+sear...
more »

2017-01-08 00:01 (1) Answers

SQL query Where Between two input

I am trying to make a search box but I am facing an issue. Here's the query i am using, I am getting the search query from database,But query is not taking the Fiyat(price),meterekare,odasayisi values from database My question is that Why I am unabl...
more »

2017-01-06 22:01 (0) Answers