awk technical questions

Search Results (60)

Results for awk

December 3rd, 2023

awk remove rows older X days inside file first days of the month problem

I have this simple file "lista_file" created every day dynamically: Fri Oct 20 20:47:58 CEST 2023 ANDREA_20231013_000002_10800s+60s_rec-uk-london-03.m...

bash

November 29th, 2023

vlookup like function with awk

1st tab separated file1: chr1 10031 10031 -> chr1 10061 10061 chr1 10037 10037 -> chr1 10047 10047 chr1 10043 1...

awk bash vlookup

November 27th, 2023

division and logarithmic calculation in AWK

I have three column file like this below. I want to divide column 3 by column 2 (ignoring headers) and print it in column 4. Also, I want to calculate...

linux awk

November 26th, 2023

awk returns two different outputs for the same input

I'm trying to get first field value using awk field separator, but it is failing as below. Same is working fine when i'm trying with echo manually. Fa...

linux bash

November 18th, 2023

Awk : an other way more elegant to do it ? See inside?

I wrote a awk program which give me the result i needed. Finding any line beginning with 130AB : if the 2nd field contain data, move it on the 9th fie...

awk separator

November 16th, 2023

Combine awk output field to corresponding integer

I'm trying to extract version numbers from lines in a file like below: grep abc | awk '{print $3}' somefile and getting multiline output as: 7.2.5.200...

awk bash shell

November 13th, 2023

How to make this awk script less boilerplate?

Suppose I've got a log file like this (1st column is a timestamp): 1699740442177 Start A 1699740442177 Start B 1699740442255 Start C 1699740442261 Fin...

awk refactoring

November 1st, 2023

How to use awk to capture multiple patterns in text file into several blocks of text and print each block to a new file

I have this bind dns stats text file, sample_data.txt: +++ Statistics Dump +++ (1698804161) ++ Incoming Requests ++ 34199522 QUERY ...

awk bash sed grep

October 31st, 2023

awk how to iterate over two different paths

I have two directories in /home/: dirA and dirB. Files in dirA: fileA.txt fileB.txt fileC.txt Files in dirB: fileA.yaml fileB.yaml fileC.yaml Expected...

awk bash

October 25th, 2023

Is there a way to use awk to count the number of rows between 2 flags and input that number into a specific field?

I have a set of data that consists of seismic wave travel times and their corresponding information (i.e. source that produced the wave and the time f...

awk counting reformatting

October 23rd, 2023

awk how to print whole column if match

This is data.txt: +----------------------------+---------+-------------------+ | Hostname | Plan | Server | +---------...

awk

October 23rd, 2023

awk + export value to awk not passed

I am using the following awk (from my previous post - how to get list of folders that older then 30 days ) in order to print the folders that are olde...

linux awk bash

October 20th, 2023

Using AWK command to skip first line and determine if a '/' is in specific column which happens to be a date in a CSV file

Using AWK command to skip first line and determine if a '/' is in specific column which happens to be a date in a CSV file, although for my request t...

awk shell

November 25th, 2023

Is there an equivalent to awk sprintf for use in C compiler #define directives

For context, I am trying to do some simplistic localization, as a first step into that "ocean", with limited language options. I want to be more "inc...

c c-preprocessor

September 29th, 2023

Error when using AWK Command for Filtering and Matching Data from Two Files

I have two files one which includes 3 columns, called Chromosome and Gene_start Gene_end. The first column contains a number and Gene_start Gene_end c...

awk

September 28th, 2023

AWK syntax error when the variable output has a full stop in it

I am trying to add this variable (it takes the batch job number and extracts the ID from a text file, with one ID being a new row) so that it can be i...

awk bash syntax-error

September 27th, 2023

AWK Duplicate subtitute

Trying to use awk to substitute duplicated value by a "counter" I have this example list: (there is duplicated mac ba484ebce594, but the duplicates wo...

macos awk duplicates

September 27th, 2023

Remove last character from lines if it matches with bash/awk

I have a load of csv files, but they are not clean. They use "|" as a seperator. Some of the files have a trailing "|" after line one, meaning there i...

csv awk bash sed

September 25th, 2023

How to choose which array to loop through before running awk for loop?

Using awk (not gawk) I would like to iterate through one of two arrays, depending on the value of a separate variable. One array contains a subset of ...

arrays awk variable-assignment

September 25th, 2023

How to reproduce awk warning "Invalid multibyte data detected"?

I'm getting this warning from awk, when it processes a long file on a server: Invalid multibyte data detected. There may be a mismatch between your da...

awk bash encoding unicode

September 21st, 2023

Using AWK to filter csv data by column values, with wildcards

I have a csv file that contains lines such as 1 Er6 Te100 7.02455 1 0 0 -0.00420 2 Cu7 ...

awk wildcard

September 13th, 2023

Skip row value(s) with awk

I have the following input file: -0.805813 0.874753 -0.776101 -0.749147 -0.636834 0.379035 -0.004061 -0.004061 -0.426119 -0.024801 -0.041989 -0.783...

awk sum row sequential

September 11th, 2023

How to input egrep result as a variable to awk

I have a dataset that looks like the below: col1,col2,col3,col4 read1,chr1,Unassigned_NoFeatures, read2,chr2,Assigned, read3,chr3,,Assigned What I wan...

awk bash grep

September 10th, 2023

awk for loop how to see if one line exists in another file and compare dates lines of both files

This is file-old.txt: nextduedate: '2023-09-06' dedicatedip: 1.1.1.1 nextduedate: '2023-09-01' dedicatedip: 2.2.2.2 nextduedate: '2023-09-08' dedicate...

awk bash

September 5th, 2023

Linear lnterpolation using awk

I have a data file with following format: 1 3 2 3 5 2 3 2 4 3 3 3 2 2 4 4 3 2 2 -6 5 3 2 2 -4 I would like to linearly interpolate...

awk

Search Results (60)

Hot Topic