titus | Deploy useful features in sprint | Authentication library

This should work.

In VBA, the SendKeys command is a member of the global Interaction module and, thus, always in scope.

In VBScript, you need to use the SendKeys method of the WScript.Shell object instead:

You seem to be suggesting that Grant is a column name -- bad choice, but you are stuck with it. The standard way to escape names is to use double quotes:

It does not match as it expects 2 characters using (([ .)\n|])([^a-zA-Z])) where the second one can not be a char a-zA-Z due to the negated character class, so it can not match the s in Jude some.

What you might do is make the character class in the second part optional, if you intent to keep all the capture groups.

You could also add word boundaries \b to make the pattern a bit more performant as it is right now.

See a regex demo

(Note that Jude is listed twice in the alternation)

If you only want to use 3 groups, you can write the first part as:

Here

Since you already have the format in the {'LAT'=X, 'LON'=Y}, the easiest way might be to simply use it as a basis to generate the format you desire:

You need to use the data that is stored in $postagem in your echo statements. Currently, you are assigning your POST values to $postagem instead of using the members within the $postagem object. See the PHP manual on mysqli_fetch_object for more info on this.

Your code should look something like this:

you should change your code, like this:

Apps script Webapp can receive inputs from

• google.script.run in published webapp hosted on script.google.com
• post using doPost from anywhere in the internet

You can post to your webapp and receive back data. Alternatively, if the intention is just to get data from Google sheets, you can use sheets api(google-sheets-api) to get data.