Search Results

Duplicated the question

Hi All,

I have two files file1 and file2(lookup file).I need to map more than one keyfields of file1 with file2.how can we achieve it using awk.

file1(max 2.2 million records)...

Hi gurus,

Can i use regular expressions to ftp files like this

ftp -v -n -i << EOF > FTPERRLOG2.log
open <<host>>
user <<username>> <<passwd>>
prompt off
ls test[0-9]{2}*...

Hi,

I am trying to use join command for two files of size greater than 1 GB.
join -t , -1 2 -2 1 -o...

Hi vish_indian,

Many Thanks,for clearing my doubt.

Regards,
Sukumar.

Hi vish_indian,

Thanks.But can we specify the field numbers to sort inside the awk like what we have specified in basic sort command.


Regards,
Sukumar.

Dear All,

How can we sort using awk?Is there anything by default

Please help me.

Regards,
Sukumar

Hi ghostdog,

This is not just a comparison,I am trying to achieve deletion and moving of files after text processing.

The below example is a simple try for unix commands inside awk.




...

echo $h|awk '{
"if [ "'$h'" -eq "hi" ]
then
echo "Success"
else
echo "Failure"
fi"
}'

I dont know where iam right or not.please help me

Hi All,
I try to use the unix commands inside awk and couldnt succeed .
Please help me how to achieve it.







Regards,
Sukumar.

Hi All,
sorry for rephrasing.
while finding duplicates I will use file naming convention(substring of files 1,4) and file size too.

Hi,

I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one...

hi ygor,

I have understood the script,but one more issue is that the script is taking more time if my file 1 and file2 exceeds more than 5000 records,

As we are taking file2 in array,what will...

Thanks a lot ygor
great script.works fine
As iam new bie to awk,can u explain me ygor.

Thanks and Regards,
sukumar

Hi All,

a new bie to awk,

How to compare substring of col1,file 1 with
col2file2 and get file1contents+col3file2 as output.

file1
-----
kumarfghh,23,12000,5000
rajakumar,24,14000,2500...

hi blowtorch,

Iam also getting the same problem,can u tell us the limit of ls command.
till how many file will it work.

Hi,

As i have said its a one-one mapping,but the columns can be dynamic.
It can be col X(file1)-col 1(file2) ,colX,colY(file1)-col1col2(file2).Is it possible with the current script.

Yah....
Its a one to one mapping between the files..

file1
-------
a;a;c;
d;f;g;
3;7;8;

file2
------
4;7;8;
3;4;7
a;a;c;
d;f;g;

success file1
-----------
a;a;c;
d;f;g;

Hi Grial,
Again thanx for ur kind repsonse,Let me explain clearly.
I have compared col3 of file1 and col3 of file2.
I got duplicates of file1 with the latest script send by you.
And one more...

Hi Grial,
Thanks for your prompt and quick response.

The script works for comparing two cols i.e., col 3 and col4 of two files.

If i try to try to compare only col3 of two files,
I am getting...

Sorry girish,

I have given the column info wrongly,
Its col3 and col4 of file1 to col3 and col4 of file2 comparison.

Hi,
I have two files file1 and file2 delimited by semicolon,
And I want to compare column 2 and column3 of file1 to column3 and column 4 in file2.

file1
--------
abc;cef;155.67;143_34;...