strf | Radio Frequency Satellite Tracking | Navigation library

In vue.js 2.0 I'm trying to make a compute a class like this:

...

I have this bot that checks everytime someone sends a message using an on_message event and for some reason the other commands that the bot has seem to be ignored. I figured that out after removing the function of checking the msgs and the commands work pretty fine.

Here is the on_message event code:

...

I was trying to select all the columns in the table where the "month" and "year" are the same. The method rawQuery(query,args) receive an array of string[] with the a query that replaces the camps with "?".

This was some of my attempts:

...

I have following Dataframe in R.

...

BACKGROUND

I have three large tables (employee_info, driver_info, school_info) that I have joined together on common attributes using a series of LEFT OUTER JOIN operations. After each join, the resulting number of records increased slightly, indicating that there are duplicate IDs in the data. To try and find all of the duplicates in the IDs, I dumped the ID columns into a temp table like so:

Original Dump of ID Columns first_name last_name employee_id driver_id school_id Mickey Mouse 1234 abcd wxyz Donald Duck 2423 heca qwer Mary Poppins 1111 acbe aaaa Wiley Cayote 1234 strf aaaa Daffy Duck 1256 acbe pqrs Bugs Bunny 9999 strf yxwv Pink Panther 2222 zzzz zzaa Michael Archangel 0000 rstu aaaa

In this overly simplified example, you will see that IDs 1234 (employee_id), strf (driver_id), and aaaa (school_id) are each duplicated at least once. I would like to add a count column for each of the ID columns, and populate them with the count for each ID used, like so:

ID Columns with Counts first_name last_name employee_id employee_id_count driver_id driver_id_count school_id school_id_count Mickey Mouse 1234 2 abcd 1 wxyz 1 Donald Duck 2423 1 heca 1 qwer 1 Mary Poppins 1111 1 acbe 1 aaaa 3 Wiley Cayote 1234 2 strf 2 aaaa 3 Daffy Duck 1256 1 acbe 1 pqrs 1 Bugs Bunny 9999 1 strf 2 yxwv 1 Pink Panther 2222 1 zzzz 1 zzaa 1 Michael Archangel 0000 1 rstu 1 aaaa 3

You can see that IDs 1234 and strf each have 2 in the count, and aaaa has 3. After generating this table, my goal is to pull out all records where any of the counts are greater than 1, like so:

All Records with One or More Duplicate IDs first_name last_name employee_id employee_id_count driver_id driver_id_count school_id school_id_count Mickey Mouse 1234 2 abcd 1 wxyz 1 Mary Poppins 1111 1 acbe 1 aaaa 3 Wiley Cayote 1234 2 strf 2 aaaa 3 Bugs Bunny 9999 1 strf 2 yxwv 1 Michael Archangel 0000 1 rstu 1 aaaa 3 Real World Perspective

In my real-world work, the JOIN'd table contains 100 columns, 15 different ID fields and over 30,000 records, and the final table came out to be 28 more than the original. This may seem like a small amount, but each of the 28 represent a broken link that we must fix.

Is there a simple way to get the counts populated like in the second table above? I have been wrestling with this for hours already, and have not been able to make this work. I tried some aggregate functions, but they cannot be used in table UPDATE operations.

...

within a dataset, there are several different datetime-strings.

For example:

2020-11-16T06:00:00Z

2020-11-16T06:00:00+01:00

2020-11-16T06:00:00+01:00Z

2020-11-16T06:00:00+02:00

2020-11-16T06:00:00.000Z

I thought about replacing everything after the seconds, but it gives me errors, when for example +01:00 isn't given in the first place.. or else.

Do you have any clou, how to handle this?

It would be absolutely enough, if I could get:

%Y-%m-%dT%H:%M

(The basics, how to strp and strf are known...)

I've wrangled my head all night about this problem. Hope, that one of you have got a solution...

thank you in advance!

...

Overall aim: Parse a string in GMT as a time using jq and output both a formatted time and the difference of that time to "now". However, jqs (version 1.6, Debian testing) timezone handling seems very confused to me:

...

How can I break down a string by spaces? I’m used to taking data before/after a word or special character or a space. However I’m working on a decoder app where my string would look like:

This is a downloaded code that would be set to a string: “09627189762”

...