awk -F, ‘{print NF}’ filename
I needed to migrate a set of tables from MySQL/MariaDB to a different SQL database recently. My source was not an actual live connection to the source database, but a SQL dump created by the mysqldump backup utility.
Found a very handy website to practice Regular Expression and just made a donation to support it.
https://regexone.com/
AWK is the abbreviation of three developers’ names.
Function: analyze the file line by line based on pattern. Syntax:
awk ' BEGIN{} /pattern/{} END{} '
시간대 별 IP 와 URL를 추출할 일이 있어서 정리합니다.
아래는 nginx access.log로그 패턴입니다.
52.78.xxx.yyy — — [05/Jul/2017:17:00:00 +0900] “POST /user HTTP/1.1” 200 0 “-” “-” “52.78.xxx.yyy”
Recently I took the SDI assessment, and in the process I was told that I liked things with structure and order, which really resonated with me when thinking about one of the things that I…
[6/5/2017 update: I was asked if I had a PDF version of the one-liners below. Here it is — Data-Science-One-Liners.pdf]
Experienced data scientists use Unix/Linux command-line utilities (like grep, sed…
