awk to compare files and validate order of headers
The below awk verifies the count and order of each text file in the directory. The script does execute and produce output, however the order of the headers are not compared to key. The portion in bold is supposed to do that. If the order of the headers in each text file is the same as key, then the file is good else the out of order header is printed. I am not sure what I am doing wrong. Thank you .
file.txt tab-delimited in /home/cmccabe/Desktop/validate/*.txt --- each text file ( usually 3) are the same format or should be ----
key tab-delimited --- order of each header (always the same) ----
awk
current output
desired output
I have a tab delimited HUGE file (13 million records) with Detail, Metadata and Summary records.
Sample File looks like this
M BESTWESTERN 4 ACTIVITY_CNT_L12 A 3
M AIRTRAN 4 ACTIVITY_CNT_L12 A 3
D BESTWESTERN FIRSTNAME LASTNAME 209 N SANBORN AVE
D BESTWESTERN FIRSTNAME LASTNAME 6997... (25 Replies)
In one of the Unix Programming FAQ's they have the following headers in the program to catch SIGCHLD
#include <sys/types.h> /* include this before any other sys headers */
#include <sys/wait.h> /* header for waitpid() and various macros */
#include <signal.h> /* header for signal... (5 Replies)
Hi. I'm new to awk and have searched for a solution to my problem, but haven't found the right answer yet. I have two files that look like this:
file1
Delete,3105551234
Delete,3105551236
Delete,5625559876
Delete,5625556789
Delete,5625553456
Delete,5625551234
Delete,5625556956... (8 Replies)
Hi ,
I have a typical situation. I have 4 files and with different headers (number of headers is varible ).
I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only).
For example -
File 1
H1|H2|H3|H4
11|12|13|14
21|22|23|23... (1 Reply)
Hi,
I have two tab separated files;
file1:
S.No ddi fi cu o/l t+ t-
1 0.5 0.6 o 0.1 0.2
2 0.2 0.3 l 0.3 0.4
3 0.5 0.8 l 0.1 0.6
file2:
S.No ddi fi cu o/l t+ t-
1 0.8 0.9 o 0.5 0.6
2 0.5 0.2 o 0 0
3 0.2 0.3 l 0 0
4 0.5 0.6 l 0 0 (1 Reply)
Hi,
I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files.
To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Please help me to compare two files and remove the items in file2 from file1
file 1:delimited using pipe(|)
file1
00012|Description - 1|||||AA12345|1|AB12345|2|2012/06/03
AB123|Description - 2|||||AA12345|3|ZA11111|4|2012/06/04
11111|Description - 3|||||AP00012|1|AB12345|2|2012/06/03... (8 Replies)
Dear all,
I have a csv file which is transformed to .dat. I have an awk file which is supposing to do the mapping of the dat file. the code from the awk file is the one below.
The content of the dat file is looking like this (tab separated):
ODT AGE CDT CO SEX TIME ... (9 Replies)
I have a below requirement and trying to compare the files using awk
File 1 - Already stored on a prev day
id | text | email id
---------------------------------
89564|this is line 1 | xyz@sample.txt
985384|this is line 2 | abc@sample.txt
657342|this is line 3 |... (3 Replies)