rue | PHP library for all of Runescape 's web services | REST library

If this is VBA, I have a fix for you (please forgive the crappy naming convention, I'm scribbling this down in work while waiting for SQL to refresh):

The most basic solution is to use the default Javascript Array.sort method and pass your own compare function.

In the example below I check if there is any input and depending on that I sort just alphabetically, or I sort by input(by checking with the Regular Expression if the element starts with input) and then sort alphabetically.

The solution was to change :

Here's a very simple example that matches just things like "*strasse [number]":

Regarding the formatAddress() helper function you defined, there doesn't appear to be an issue with it in it's current form. It can happily run through the entire list of 644 addresses ~210 times per second.

Any timeouts are instead likely to be caused by performing so many database writes in quick succession. When running fetchDataFromURL(), you "spam" the Firestore server with a request for each toilet object you are uploading.

The best-practice approach would be to compile a Batched Write and then commit the result once you've finished processing the data.

As stated in that documentation:

A batched write can contain up to 500 operations. Each operation in the batch counts separately towards your Cloud Firestore usage. Within a write operation, field transforms like serverTimestamp, arrayUnion, and increment each count as an additional operation.

Note: The current list of field transforms includes serverTimestamp, arrayUnion, arrayRemove, and increment. Reference: FieldValue

Creating/deleting/writing a document to Firestore is considered "one operation". Because a field transform requires reading the document, then writing data to that document, it is counted as "two operations".

Because a single batched write is limited to 500 operations, you should split your data up into smaller batched writes so that each batch is less than this 500 operations limit. The easiest way to achieve this would be to use this MultiBatch class (included below) that I've updated from one of my old answers.

• If the data you are writing to a Cloud Firestore document is just basic data, use one of multibatch.create(), multibatch.delete(), multibatch.set(), or multibatch.update(). Each time one of these is called, the internal operations counter is increased by 1.
• If the data you are writing to Cloud Firestore contains any FieldValue transforms, use one of multibatch.transformCreate(), multibatch.transformDelete(), multibatch.transformSet(), or multibatch.transformUpdate(). Each time one of these is called, the internal operations counter is increased by 2.
• Once the internal counter exceeds 500, it automatically starts a new batched write and adds it to it's internal list.
• When you've queued up all your data ready to send off to Firestore, call multibatch.commit().

An idea is to set the copy_to mapping parameter to the name and landlords.name fields, in order to copy the values of both fields into another field (say, names) that you will use for your search.

So your mapping may look like:

That's because you are trying to map over an object.

.map()is an array method.

maybe you want to loop over the results array (data.results)?

Here a working regex to capture your text starting with a digit either at start or at the end: