I need to compare two separate product lists that are changed weekly. New products are added, old products are removed and prices change.
I have found various Windows programs that do this function but it's not as clean as I like and just wondered if there was a simpler way with something like AWK or SED
Both files come in a tab delimited format, although I can easily modify this. The samples below show 7 columns:
Name
Category
Quantity
Manufacturer
Image
Price
Weight
File 1
File 2
As you can see, the following are:
1. The 3rd product from File 1 has now gone
2. The price of the 1st product from File 1 has increased to 7.49
3. Two new Filippo products from File 2 have been added
I need a produce a merged file which has the new prices for each product, the old products taken out and the new products added. Is this possible easily with AWK / SED or easier sticking with a Windows product?
Any help kindly appreciated.
Last edited by Franklin52; 03-25-2011 at 10:19 AM..
Reason: Please use code tags
Hi,
I have a file like this.
"2006","10",25,"U","1129","32","C",0,0,0,0,0,0,0,0,0,0,0,0,352,16,4,0,0,0,0,0,"80",,1
"2006","11",25,"U","1148","32","C",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"80",,2
"2006","14",25,"U","1149","10","C",0,0,0,0,0,0,0,0,0,0,0,0,560,12,0,0,0,0,0,0,"80",,3... (1 Reply)
Hi,
I have written a script which would FTP a dump file to the FTP server and log the whole activity into a file. to confirm the success of the file copy i grep for "226 file receive OK" and then send out an email saying success. Now i want to make sure the bytes of the local file and... (4 Replies)
HI,
I would like to know how to compare two files and replace non-matching lines with "_" .
I can get non-mathing lines with
grep -v -f file1 file2
i just want to knw how to display 'file2' with non-matching lines from 'file1' replaced by "_"
for exmaple
file1:
a
b
c
d
... (2 Replies)
Hi All
I have to files
cat a.txt
AAA
BBB
CCC
DDD
and
cat b.txt
AAA
CCC
EEE
i want to compare these two files and o/p should have content of file a.txt which is not in file b.txt
c.txt
BBB
DDD
Please help me (1 Reply)
Hi All
I have to files
cat a.txt
AAA
BBB
CCC
DDD
and
cat b.txt
AAA
CCC
EEE
i want to compare these two files and o/p should have content of file a.txt which is not in file b.txt
c.txt
BBB
DDD
Please help me (3 Replies)
Hi Gurus,
I have to fetch the records from a logs as per the time stamp . I am comfortable to use awk and sed in the script . But the logic to fetch the records as per comparison is the problem. $cat my_log.log
<Jul 30, 2010 7:01:12 AM EEST> <Error> <WebLogicServer>
<Jul 30, 2010 8:04:12 AM... (3 Replies)
Hi All,
I want to write a script which will compare two files and tell me if the files are different.
Actually my files will be same but order of lines will be different,so diff is not working.
I have written a script to do this:-
while read line; do
cnt=`grep -i $line... (6 Replies)
Hi all,
Currently i am using
if( $0~/ NOT / && $0~/ NULL /)
{
.................
}
to check if the input record contains "NOT" and "NULL". But in some cases "NOT" and "NULL" are preceded and followed by tab. How do i find compare for these fields as well? (3 Replies)
Hi Everyone
I am new to Unix shell scripting
Can anyone please explain me in detail how this command works
awk -F@ 'NR==FNR{A=$2;next}$3 in A{$3=A}1' file2 file1
The above command I got it from this forum, but unable to implement it as I am not getting how this works:mad:
I... (3 Replies)
Hi All,
I have two files in the following format.
File 1 :
1044|1|20121031|2910039.4|MR|201210|G1044|E
1082|2|20121031|1664662.84|MR|201210|G1082|E
1696|3|20121031|190801.5|MR|201210|G1696|E
1824|4|20121031|196350|MR|201210|G1824|E
1900|5|20121031|221447.8|MR|201210|G1900|E
File 2 :... (7 Replies)
Discussion started by: nua7
7 Replies
LEARN ABOUT NETBSD
weekly
WEEKLY(5) BSD File Formats Manual WEEKLY(5)NAME
weekly, weekly.conf -- weekly maintenance
DESCRIPTION
The /etc/weekly script is run, by default, every Saturday morning on a NetBSD system. The /etc/weekly.conf file specifies which of the stan-
dard weekly services are performed.
The variables described below can be set to ``YES'' or ``NO'' in the /etc/weekly.conf file. The default settings are in the
/etc/defaults/weekly.conf file. (Note that you should never edit /etc/defaults/weekly.conf directly, as it is often replaced during system
upgrades.)
rebuild_locatedb This rebuilds the locate(1) database, /var/db/locate.database, which must also exist, in order to be rebuilt.
rebuild_mandb This rebuilds the apropos(1) database /var/db/man.db, using makemandb(8) with the -f option.
rebuild_whatisdb This rebuilds the whatis(1) database(s). Note that NetBSD provides a default whatis.db for the system manual pages and
this may not be needed. (Adjust your /etc/man.conf as necessary; see man.conf(5) for details.)
FILES
/etc/weekly weekly maintenance script
/etc/weekly.conf weekly maintenance configuration
/etc/weekly.local local site additions to /etc/weekly
SEE ALSO daily.conf(5), monthly.conf(5)HISTORY
The /etc/weekly script first appeared in 4.3BSD. The /etc/weekly.conf configuration file appeared in NetBSD 1.3.
BSD March 6, 2012 BSD