I would like to rename pdf files I have in an AWS S3 bucket, changing their names from some sort of numbers we use, into UUIDs we have in a PostgreSQL table. Currently, I'm trying to do it like this:…
I'm trying to write an AWK script that would check if there are any prime numbers in a file and print them. Here is my code: #!/bin/awk -f function is_prime(n) { if (n <= 1) return 0; if (n ==…
I wrote a script which takes values from a CSV file and inserts in into a postgres table, but was facing a problem. The date columns in the CSV file are in 'YYYYMMDDHH24MISS' format, and the same column in the…
I am trying to replace this: The numbers at the start of the line will always be 3 digits, 0 padded, there may however be empty lines or regular sentences prior, as shown in my full example that has echo.…
I am trying to mask/hide a value of a field in a json file. I have json that looks something like this: "PLUSDATA": { "global": { "auth_type": "login", "passkey": "SENSETIVE_CONTENT_TO_BE_HIDDEN", "src_intf": "Loopback0", "timeout": "5" } }, I'd like to parse…
I have a json file input.json thus: { "foo":{ "prefix":"abc", "body":[1,2,3] }, "bar":{ "prefix":"def", "body":[4,5,6] } } I would like to sort it by the outer object names, with "bar" coming before "foo" in alphabetical order like so: { "bar":{…
I would like to find IP addresses and user agents that have made more than 10 server requests per second. Help me, please. How can I do this? Maybe with awk, grep? Here's a typical lines from my Access Log:…
I want to fetch some data from below JSON code: I'm able to get the output using below command but now I want to format it in such a way that my output will look like the expected output. Command:…
I have this command which displays all the record from the search. But I would like to filter only the record that matches the search word. For e.g. for user in $(aws iam list-users |grep -i UserName|sed -e 's/.*: "//'…
How do I replace part of url string without knowing beforehand what the string would be ? For example below is Ubuntu mirror. I want to set mirror to my liking. Basically, I want replace (jp, us provided as an…