Questions tagged [awk]

AWK, a high-level scripting language, was meticulously crafted for accomplishing proficient text manipulation tasks and is commonly employed for data extraction as well as generating reports. Unix systems prominently embrace the powerful capabilities of AWK for diverse applications.

Connecting JSON objects based on unique GUID values generated

I am in search of a method to automate the laborious task of linking multiple JSON objects with random GUIDs. The JSON files are all interconnected: { "name": "some.interesting.name", "description": "helpful desc ...

Matching patterns and removing four lines that match the specified pattern

I currently have 2 separate files that I am working with. Within File 1, there is an Identifier (e.g. DF:1:1) as well as an additional field of "1:N". The following 3 lines are specific to the given Identifier. File 2 contains a column of various Identifie ...

python sed awk

Display the output of awk on a single line for specific columns

Here is a file called "test" that displays the following information: vserver share-name path acl TEST_SERVER TEST_SHARE_PATH /TEST/TESTSHAREPATH "test estuser / Read","test estuser1_R / Read","test estuser2_RW / Change" The ACL segm ...

html awk

What is the best way to add a new line following every awk command in Python code?

Is there a way to insert a new line after each string is found in Python? Any assistance would be highly appreciated, and I am open to other search methods like GREP or SED. I need something that can scan through the output, identify key words, and display ...

python python-3.x awk grep

To identify a specific field within a JSON file by cross-referencing it with a plain text file and extracting the corresponding values

Having two files, file1.json and a plain text file called file2. I need to compare the values in file2 with the values in file1.json and extract the corresponding CaseID from file1 based on matching values. Below are some cases along with the expected resu ...

json awk sed file-comparison

Retrieve lines from a document that fail to meet specific requirements

To tackle the issue, my goal is to extract lines from a file that do not contain the specific pattern: "ddd":[ The target is to filter out lines like "memo": { or "notice": "delivered on 17", and only retrieve lines containing "ddd":[, disregar ...

json bash awk sed jq

Is it possible to use a shell script to replace the external CSS file link in an HTML file with the actual content of the CSS file

Seeking a solution for replacing external CSS and JS file links in an HTML document with the actual content of these files. The current structure of the HTML file is as follows: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C ...

javascript html css awk sed

Transforming numerous key-value pairs into JSON formatting: utilizing sed in conjunction with an awk for loop

I am currently working with a data file that has 8 columns delimited by pipes. The last column contains an unpredictable number of key-value pairs, each separated by the equals sign and spaces between each pair. However, the challenge is that the values wi ...

json bash awk sed

How can we ensure the JSON output is easily searchable with grep?

The JSON structure I have is as follows: { "1":{ "state":{ "on":false, "bri":124, "hue":14985, "sat":252, "effect":"none", "xy":[ 0.5182, 0.4363 ], ...

json linux bash awk grep

Discovering key value pairs on a Linux server

I need to extract a key pair from improperly formatted JSON data, making it impossible to use tools like jq. The data also doesn't display in any specific order, ruling out extraction by columns or field numbers. What is the most effective approach for th ...

json regex linux awk grep

Newtab Q&A