Clojure: creating a date-time object for the JDBC

I created my PostgreSQL table with a column: updated_at timestamp(0) with time zone I’m using clojure.java-time but I can’t create a string (or should be an object?) to set the current date-time. I tried with: (time/format “yyyy-MM-dd HH:ss” (time/local-date-time)) and with that string I tried: (db/update-answer! {:updated_at “2019-12-25 14:08”, :id 102, :answer “Foo”} but the…

Details

How to get rows that doesn’t have values start with specific pattern in a pipe delimited file?

I am trying to get only the rows that don’t have values start with a certain patterns. Input file (test_file.txt) USER1|AR-45233| USER4|AR-32133| USER1|45232| USER1|AF-45233| USER2|AR-12321| SYSTEM1|A9-12312| USER1|AP-67655| Expected output (test_filtered.txt) USER1|45232| SYSTEM1|A9-12312| I tried this and it appears to be working. Is there a better way to achieve the same? awk -F “|” ‘{if ($2!~/AP-/…

Details