Differences

This shows you the differences between two versions of the page.

--- fuss:awk [2017/02/22 18:30] – external edit 127.0.0.1
+++ fuss:awk [2018/01/02 01:47] – [Convert Key-Value Map to JSON] office
@@ Line 44: / Line 44: @@
 </code>
+====== Merge Lines by Two in File ======
+Given a file with the contents:
+<code>
+Q: What is this?
+A: This is a FAQ!
+</code>
+and you would like to achieve:
+<code>
+Q: What is this? A: This is a FAQ!
+</code>
+then the following ''awk'' one liner:
+<code bash>
+awk 'NR%2{printf "%s ",$0;next;}1' yourFile
+</code>
+will merge all the lines in a file by two.
+====== Convert Key-Value Map to JSON ======
+Given an input such as:
+<code>
+a1 : "abc
+c2  : def
+e3 : "ghi "
+f5 :" a     b"
+</code>
+The following awk script:
+<code bash>
+awk -F: '
+    function trim(s) {
+        return gensub(/^[ \t"]*|[ \t"]*$/, "", "g", s)
+    }
+    BEGIN {
+        printf "{"
+    }
+    NR > 1 {
+        printf(", ")
+    }
+    {
+        printf("\"%s\":\"%s\"", trim($1), trim(substr($0, index($0,":") + 1)));
+    }
+    END {
+        print "}"
+    }
+'
+</code>
+will return the JSON object:
+<code>
+{"a1":"abc","c2":"def","e3":"ghi","f5":"a     b"}
+</code>
+where keys and values are trimmed for spaces and quotes from the start and end.
+[[iot/openhab2/templates/apc_ups|One example application]] would be creating a JSON object out of the status of an APC UPS:
+<code bash>
+apcaccess | awk -F: '
+    function trim(s) {
+        return gensub(/^[ \t"]*|[ \t"]*$/, "", "g", s)
+    }
+    BEGIN {
+        printf "{"
+    }
+    NR > 1 {
+        printf(", ")
+    }
+    {
+        printf("\"%s\":\"%s\"", trim($1), trim(substr($0, index($0,":") + 1)));
+    }
+    END {
+        print "}"
+    }
+'
+</code>