Maiar's Vault

In google sheets, how to address the current cell in conditional format custom formula?

2018-07-18T10:05:00.007-04:00

Short answer:=INDIRECT(ADDRESS(ROW(),COLUMN()))

Example:

If current cell is divisible by 12 apply conditional formatting.
=EQ(MOD(INDIRECT(ADDRESS(ROW(),COLUMN())),12), 0)

Conditional formatting only looks that you return a true or false value E.G. =1 or =true (aka a truth value)

Valid conditional custom formula:

=1

How do you interpolate strings in Elixir?

2018-03-27T17:12:00.000-04:00

How do you interpolate strings in Elixir?

You use #{} in strings to add in elixir

iex> IO.puts "Hello #{:world}"

What are booleans in Elixir?

2018-03-26T16:59:00.000-04:00

What are booleans in Elixir?

Booleans are actually Elixir atoms

What are boolean values in Elixir?

2018-03-25T16:57:00.000-04:00

What are boolean values in Elixir?

The two boolean values are:

iex> true
true
iex> false
false

How many ways can I write numbers in Elixir?

2018-03-24T16:51:00.000-04:00

How many ways can I write numbers in Elixir?

You can write them in:

Decimal
Binary
Octal
Hexadecimal


iex> 1.0
1.0
iex> 10
10
iex> 0b1010
10
iex> 0o777
511
iex> 0x1F
31

Where can I ask questions about Elixir?

2018-03-23T16:42:00.000-04:00

Where can I ask questions about Elixir?

You can ask on:

IRC: #elixir-lang at freenode IRC
Slack: https://elixir-slackin.herokuapp.com/
Elixir Forum: https://elixirforum.com/
Stackoverflow: https://stackoverflow.com/questions/tagged/elixir

How do I run a elixir script?

2018-03-22T16:39:00.000-04:00

How do I run a elixir script?

Type in a file:

IO.puts "Hello World!"

Then execute:

$ elixir simple.exs

How do I print output in Elixir?

2018-03-21T18:00:00.000-04:00

How do I print output in Elixir?

IO.puts "Hello World!"

What types does elixir have?

2018-03-20T18:00:00.000-04:00

Elixir data types:

iex> 1          # integer

iex> 1.0        # float

iex> true       # boolean

iex> :atom      # atom / symbol

iex> "elixir"   # string

iex> [1, 2, 3]  # list

iex> {1, 2, 3}  # tuple

iex> sum = fn (a, b) -> a + b end # tuple

iex> kw_list = [{:one, 1}, {:two, 2}] # keyword list

iex> map = %{:a => 1, 2 => :b} # map

How do you get UTF-8 in Elixir?

2018-03-20T17:02:00.000-04:00

How do you get UTF-8 in Elixir?

All the strings in Elixir are already UTF-8

How do I find the version of elixir is installed?

2018-03-19T18:00:00.000-04:00

How do I find the version of elixir is installed?

Type:

$ elixir -v

How do I install Elixir on a Mac?

2018-03-18T16:07:00.000-04:00

How do I install Elixir on a Mac?

The easiest was is to use brew

$ brew install elixir

Reference: https://elixir-lang.org/install.html#mac-os-x

How do I start Elixir?

2018-03-17T23:07:00.000-04:00

type:

$ iex

Rsync - a great tool

2018-03-15T13:15:00.001-04:00

If you haven't used rsync yet you should. It's a great tool for mirroring

http://www.samba.org/rsync/

Vi paging up and paging down

2018-03-15T13:15:00.000-04:00

In vi to page up and down type
Ctrl-b aka (^b)
Ctrl-f aka (^f)

End of line characters

2018-03-15T13:14:00.000-04:00

Global Search and Replace:
The magic command is

:line1,line2s/old_string/new_string/g

The /g is optional, it means 'do the replace everytime'.If not specified, vi will replace only the first occurrence in each line.
Special ^XX characters
To search for a ^XX character, you must use Ctrl-v (^v) in order to disable interpretation of the Ctrl commands.
A useful example:
Windows (MS-DOS) text files use RETURN/LINEFEED to end every line; Mac uses only RETURN; and Unix/Linux uses only NEWLINE (which is the same as the linefeed in DOS). To use the linux programming style:
\r\n = chr(13)chr(10) = MS-DOS
\r = chr(13) = Mac
\n = chr(10) = Linux/Unix
So when displaying an msdos ascii file with vi (or with any other text editor), you will find each and every line ended by a ^M (it's character 13, aka \r, aka ENTER). When displaying a mac ascii file, you will have a single line with a ^M at what should be each end of line.
Our MSDOS text file should look like this:

Friday the 13th^M
^M
^M
^M
Dear Sir,^M
^M
....

And our mac text file should look like that

"Friday the 13th^M^M^MDearSir,^M^M...."

[The Macintosh->Unix conversion isn't easy to do with vi macros, so we'll concentrate on msdos/windows->Unix]
MS-DOS/Windows -> UNIX conversion:
In order to remove these ugly ^M, you search for them and replace them by....nothing!
So first, let's search for those weird ^M ... but, how can you search for character 'ENTER'?
By preceeding it with ^V (Control-V). Any keystroke after ^V is accepted literally -- that is, it won't have its usual command function, if it's something like ESC, ENTER, ^Z, etc...
What the following command tells VI to do is to replace the first (since the /g option isn't set, but anyway, we only expect one) ^M on every line, with nothing (there is nothing between the last two slashes: //):
This is what you type

                     :1,$s/^V^M//

(where ^V is Control-V, and ^M is ENTER or Control-M)
note that VI doesn't display the ^V, so you'll only see

                   :1,$s/^M//

This what you actually see
And it should work...

How do I type the end of file character

2018-03-15T13:13:00.001-04:00

The end of file character is different on different operating systems so the end of line aka eof is:
Control-D on Unix
Control-Z on Windows

How do I get UTC time in seconds in oracle sql

2018-03-15T13:12:00.002-04:00

Timestamps can be confusing and difficult to work with in oracle. It
took me a little time to figure out but the following SQL will give
you

SELECT (CAST(SYS_EXTRACT_UTC(systimestamp) AS DATE) -
TO_DATE('19700101', 'YYYYMMDD')) * 86400 seconds , current_timestamp
FROM dual

the UTC time in seconds from the epoch, as a floating point number.

60 * 60 * 24 for 60 seconds * 60 minutes * 24 hours = 86400

Perl loop through days code

2018-03-15T13:10:00.002-04:00

Here is some code for looping through days
http://datetime.perl.org/index.cgi?FAQSampleCalculations
http://datetime.perl.org/index.cgi?FAQBasicUsage

#!/bin/env perl
use DateTime;
my $start_dt = DateTime->new(year => 2009, month => 4, day => 27);
my $end_dt = DateTime->new(year => 2009, month => 5, day => 18);

my $weeks = 0;
for (my $dt = $start_dt->clone();
$dt <= $end_dt;
$dt->add(days => 1) ) {
print $dt->date('')."\n";
$weeks++;
}

Vi paging up and paging down

2018-03-15T13:04:00.001-04:00

In vi to page up and down type
Ctrl-b (^b)
Ctrl-f (^f)

How to escape single quotes bash

2018-03-15T13:04:00.000-04:00

Just use my web page that I setup to escape single quotes in bash

http://www.stevemorin.com/utils/bashEscape.html

sbcl lisp access command line arguments

2018-03-15T13:02:00.000-04:00

$ sbcl --eval '(progn (print *posix-argv*)(quit))' two three

merge multple json files as object values with jq

2017-07-22T03:22:00.001-04:00

There are a number of example show you how to merge objects or combine arrays with jq. I haven't found any examples of merging json files in a single object. Here is how you would do that on the command line with jq.

jq -n '{one:$variablename1, two:$variablename2}' --slurpfile variablename1 filename_one.json --slurpfile variablename2 filename_two.json

Tmux with Native Copy and Paste

2014-09-14T22:18:00.001-04:00

This is a great tip and productivity enhancer. You can now do native copy and paste with Tmux and OSX starting with Tmux 1.8

The guys over at thoughbot put this together and it's a good tip.

You'll use the new copy-pipe command to setup defaults in your tmux config. See the details in their post.

http://robots.thoughtbot.com/tmux-copy-paste-on-os-x-a-better-future

Install a single node Yarn / HBase Cluster with a single command

2014-06-17T02:06:00.001-04:00

Setting up a cluster can be time consuming especially with all the services: (Hbase, Zookeeper, Yarn, Hive, Oozie, Ambari, HCat, HDFS, WebHCat)

Use this script and set it up with a single command.

https://github.com/DemandCube/hadoop-single-node-cluster