Search Results

thanks for your support.
Could U plz explain the code.

Thanks

Output generated by given code:

awk -F, '
> NR==FNR{a[$1$2];next}
> substr($1,1,6)$2 in a{print;s++;delete a[substr($1,1,6)$2]}
> END{print "Count="s}
> ' DATAFILE.txt CONFIG.txt
Count=

I have to count the matches field from both files:
matching fields from 1st file are:

919030055000,1
919030055000,3
919030055000,7
919030155000,1
919030155000,3
919031055000,1...

I have to count the matches field from both files:
matching fields from 1st file are:

919030055000,1
919031055000,8
919036055000,3
919040055000,7
919045123243,13

corresponded to 2nd file...

Hi,

I have two files, mentioning below
1st file:
919030055000,1
919030055000,3
919030055000,7
919030155000,1
919030155000,3
919031055000,1
919031055000,8
919031155000,1
919031155000,8...

Hi,
could U write the example in detail i.e Input file and desired output U want with performed operation.

it starts with subsD,<String>,hlr.

its fixed pattern.

hi,

fields/column are not fixed,
given code will not work properly.
suggest else.

Thanks

Hi,
Below is a single line output.

subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,common,00000000 subsD,01 02 03 04 05 00 00 00 00 07 00...

read sed command, it will help U.

Thanks for support.

Sorry dear,
given code is not working.
I tried,below is the snapshot of Output is some like ???.

./working_script.sh: line 10: BEGIN{print...

Hi,

I am trying to do something like that

FILE1=$1
FILE2=$2
FILE3=$3
awk -F, 'BEGIN{print "ID, Name, Address, remark , marks, age, amount, balance"}
FNR==1{next}...

Hi,
using give code, output is

ID, Name, Address, remark , marks, age, amount, balance
001,AA,43,rrrr,43,66,55,555
002,FF,44,gg
003,43,77,44,444
ID, Name, Address, remark ,marks,age,...

Hi Franklin52,

I applied your given code, but it gave different output :

cat file1
ID, Name, Address, remark
001,AA,43,rrrr
002,FF,44,gg

cat file2
ID,marks,age
001,43,66
003,43,77
...

join command will work only on fixed field of file(s).
if i have numbers of file in which field are not fix.
then what to do???

please describe in details.

Thanks

suppose i have 3 file like file1, file2, file3 in which

file1 contains 10 number of fields(column wise) like
ID, Name, Address, remark etc.
001,AA,43,rrrr
002,FF,44,gg

file2 contains let...

Firstly i genrate a file in which i have unique ID of each file let say Unique_ID.txt
After that on the basis of unique ID, i find the corresponding fields from 4 file and then paste it w.rt to ID....

Hello every one, plz help me out. I m using 4 files in unix, like file1, file2, file3,file4 in which primary key is ID in column(field) of 4 files.
On the bases of ID, i want the corresponding field...