bREST | RESTful framework for Arduino | REST library

Improve city name search -

Your code uses results of a French site with some pecularities. Making some modifications to the spelling in your data base allows to find cities (at least most of them) via url request .

The most typical corrections can be resolved via help function correct():

• the site uses French spelling for some cities like ROMA ~~> Rome
• additional numeric district suffixes like Marseille 11 have to be removed
• blanks have to be replaced by hyphens - connecting partial strings
• single l or d before vocals get added an apostrophe '
• all accents have to be replaced by the base character.

Change your URL assignment in the main sub to

Yes.

Method 1: with Excel

One way of achieving this would be with a 5th column containing a combination of city and country.

For example: In cell E2, put =B2&" "&D2 then fill down, to populate a new 5th column with a combination of city name and country code, with a space character in between. (You would then need to edit your code so that the routine uses this new output as the lookup base).

Method 2: with VBA

Another would be to concatenate city and country into one lookup string in VBA after pulling it from Excel like it is now, instead of concatenating it in Excel first like the above suggestion.

For example, you could try replacing this:

Here's an option:

Assuming that you are reading from a file called input.txt, this produces the desired result.

The issue here is that an empty line will be '\n', so you can't distinguish between an empty line vs other lines given that all lines will end with '\n'. Here's my suggestion using list comprehension and a for loop. Probably could do it in a single dict comprehension.

It could be done as follows by accessing the nested properties field :

You just not need second SET

I think the problem is in your FuelService.

You could change value in ports to 'others' where n <= 2 and then group by and sum.