Search Results

Hi

Thank you Makarand. The command is working fine.

Thank you all for prompt responses and efforts


-Ankita

Hi

awk version is GNU Awk 3.1.5

here again the files are- there is no space between the columns and columns are separeted with "|"
file1.txt

4001|Y
4221|Y
282501|Y
933502|N
933505|N
...

Hi Rudi,

I have exceuted the same command that you have provided.

awk -F"[\| ]*" 'NR==FNR {if ($3=="N") T[$2]; next} ($2 in T) {next} 1' file1.txt file2.txt > new.txt


but its giving me...

Hi,

Thank you
But Concern here is Some of entries as shown below,might not be the content of file2

4316|Y


Thanks
Ankita

Hi,

Thanks for the help.

i ran the command

awk -F"|" 'NR==FNR {if ($3=="N") T[$2]; next} ($2 in T) {next} 1' file1.txt file2.txt > new.txt


Its output -new.txt

4001|Y
4221|Y...

Hi

Please help me to compare two files and output into a new file
file1.txt

15114933 |4001
15291649 |933502
15764675 |4316
15764678 |4316
15761974 |282501
15673104 ...

Its working.Thank you :)

Hi,
Please help How to compare two files-
Any mismatches 2nd and 3rd column's values corresponding to 1st column.

file1
15294024|Not Allowed|null
15291398|Not Allowed|null
15303292|Dropship...

Hi,

Thanks for the command.

Output file would be-
10001093|234
10001093|40
10003251|4683
10003251|463005
10003252|46
10003260|468
23450986|123

Ankita

Hi,
Below are the sample data for txt files.

txt file 1
Partnumber|catgroup_id
10001082|46016
10001093|4680
10001093|386003
10001093|463004
10003251|683
10003251|63005
10003252|463005...