From Wikipedia:
AWK is a domain-specific language designed for text processing and typically used as a data extraction and reporting tool. Like sed and grep, it's a filter, and is a standard feature of most Unix-like operating systems.
We can do all sort of things with awk, for example suppose that we have a CSV file which contains list of cities, Now we want to take this file and turn it into a JSON file, all we need to do is go to terminal and type this command:
awk 'BEGIN {
print "{ results: [" }
END {
print "]}\n"
}
{ gsub(/"/, "", $2) gsub(/"/, "", $3) gsub(/"/, "", $4)
print "{ id: " $1 ", name: \"" $2 "\", countryCode: \"" $3 "\", district: \"" $4 "\" }"
}' cities.csv
In fact awk is a programming language which means that it if, loop, variable assignments,...:
awk -v date="$(date)" -v title="Report Generated By Sirwan Afifi" -F';' 'BEGIN {
SPACE = 50;
printf("%s \n", title)
print "{ results: [" }
END {
print "]}\n"
for(space = 0; space < SPACE; space++) printf "-";
printf("\nFound %d results\n", city)
printf("Report generated at %s\n", date)
space = 0; do { if (space == 0 || space == 49)
printf "*"
else
printf "-"; space++
} while (space < SPACE);
print "\n"
}
{ city = city + 1
gsub(/"/, "", $2) gsub(/"/, "", $3) gsub(/"/, "", $4)
print "{ id: " $1 ", name: \"" $2 "\", countryCode: \"" $3 "\", district: \"" $4 "\" }"
}' cities.csv
Top comments (0)