Hai To t0hai

## gist:3324739a94cd464f5238b1fff4c0c9c6
:%s/\("Key": "\({[^}]*}\)"\)/\=join(map(split(submatch(2), ',\zs'), 'printf("json_extract(Key, ''$.%s'') AS %s", matchstr(v:val, ''"\zs[^"]\+''), matchstr(v:val, ''"\zs[^"]\+''))'), ",\r  ")/g

## gist:2041670ecc40ffc0d89455c35900d196
## create empty environment
conda create -n py39

## activate
conda activate py39

## use x86_64 architecture channel(s)
conda config --env --set subdir osx-64

## install python, numpy, etc. (add more packages here...)

## replace_env_vars
envsubst < deploy.yml | kubectl apply -f -

## regexp_find_block_without_word
(_dynamic\s*)\{((?:\n(?!\}|.*type).*)*?)\}\n

## python_replace_json_single_quote
json.loads(json_str.replace("'(?=[:,\}])", '"').replace("?<=(:\s))'", '"').replace("(?<=\{)'", '"'))

## git_multi_revert
git reset --hard #commit
git reset --soft @{1}  # (or ORIG_HEAD)
git commit

## sed_jump_to_line
sed -n '52p' # method 1
sed '52!d' # method 2
sed '52q;d' # method 3,  efficient on large files

## sed_awk_count_characters.txt
sed -e 's/[^\t]//g' test_rnd.tsv | awk '{ print length }' | grep -nr '3[1-9]'

## vim_underscore
:%s#\C\(\<\u[a-z0-9]\+\|[a-z0-9]\+\)\(\u\)#\l\1_\l\2#g
	## create empty environment
	conda create -n py39

	## activate
	conda activate py39

	## use x86_64 architecture channel(s)
	conda config --env --set subdir osx-64

	## install python, numpy, etc. (add more packages here...)
	git reset --hard #commit
	git reset --soft @{1} # (or ORIG_HEAD)
	git commit
	sed -n '52p' # method 1
	sed '52!d' # method 2
	sed '52q;d' # method 3, efficient on large files