Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: fao ahamed help with script
Top Forums Shell Programming and Scripting fao ahamed help with script Post 302605626 by slashbash on Thursday 8th of March 2012 03:27:35 AM
Old 03-08-2012
fao ahamed help with script
picked this up from another thread.

Code:
echo 1st_file.csv; nawk -F, 'NR==FNR{a[$1OFS$2OFS$3]++;next} a[$1OFS$2OFS$3]{b[$1OFS$2OFS$3]++}
END{for(i in b){if(b[i]-1&&a[i]!=b[i]){print i";\t\t"b[i]}else{print "NEW:"i";\t\t"b[i]} } }' OFS=, 1st_file.csv *.csv | sort -r

i need to use the above but with a slight modification..

1.compare against 3 month records i.e 1st file = 08_03_2012 compared to all files in previous months up to 08_12_2011 any lines repeating more then > 20 is printed off and incremented with total

2.continue with above of comparing 08_03_2012 with all file records & anything not matching is printed off as new

can this be done, a question for ahamed please
 

4 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

LEARN ABOUT REDHAT

pilot-addresses

pilot-addresses(1)					      General Commands Manual						pilot-addresses(1)

NAME

       pilot-addresses	- read and write address book databases to and from a Palm handheld device, such as those made from Palm, Handspring, Han-
       dera, TRGPro, Sony or other Palm Compatible Handheld PDA device

SYNOPSIS

       pilot-addresses -p <port> [-c category ] [-d category ] [-r file | -w file ]

       (Note that some options are not shown above)

DESCRIPTION

       pilot-addresses allows the user to read all entries in the Palm address book database, write new entries into the database,  and  delete  a
       category or delete all entries in the database.

TARGET DEVICE

       The  default  serial  device  used to communicate with a Palm is /dev/pilot.  If the environment variable $PILOTPORT is set, its value will
       override the default. A serial device specified on the command-line will be used regardless of any $PILOTPORT setting.

OPTIONS

       Several options exist, including...

       -p --port <port>,
	      Use device file port to communicate with the Palm handheld device. If this is not specified, will look for the  $PILOTPORT  environ-
	      ment variable. If both are not found, will fall back to /dev/pilot.

       -h --help
	      Display help synopsis for pilot-addresses

       -v --version
	      Display version of pilot-addresses

       -a     Augments	fields in address book records with additional information.  The augmented information is placed before and separated from
	      the field with a semi-colon, (;).

	      Augmented information includes:
	      category_name - placed in front of each record or

	      ["Work" | "Home" | "Fax" | "Other" | "E-mail" | "Main" | "Pager" | "Mobile" ] - placed in front of each phone number field.

	      Empty fields are not augmented.

       -c category
	      Install records to category category by default. Normally pilot-addresses uses Unfiled as the default category. This option is over-
	      ridden by the category specified in the record with the -a option.

       -d category
	      Delete all records in the specified category before installing new records.

       -D     Delete all address book records in all categories. Obviously, be very careful with this one.

       -e     Escape  all  special  characters	with a backslash. This enables you to read and write entries with newline characters in a field or
	      note.

       -q     Causes pilot-addresses to be quiet and not prompt you to press the HotSync button.

       -r file
	      Reads records from file and install them to the Palm address book database. (Use the -w file  to	get  a	template  file	for  input
	      records.)

       -t delim
	      Include  category  in  each record, use the delimiter specified to separate all fields of a record. Delimiters are specified as fol-
	      lows: 3=tab, 2=;, 1=,.  This overrides the default delimiter of comma between fields and	semi-colon  between  a	field's  augmented
	      information. (Please note that this may generate confusing results when used with the -a option.)

       -T     Write a header line with field titles as the first line of the data file.

       -w file
	      Get all address book records from the Palm address book database and writes them into file

USAGE

       The  program will connect to a target device and port, prompt the user to HotSync, and perform the requested read or write operation speci-
       fied by the user.

EXAMPLES

       To write all address records in a Palm to the file addrbook.csv:
	      pilot-addresses -w addrbook.csv
       or
	      pilot-addresses -p /dev/irnine -w addrbook.csv

       To read the address book records in the file addrbook.csv and install them on a Palm:
	      pilot-addresses -r addrbook.csv

       To read the address book records in the file addrbook.csv and place them into the Palm address book database category Special  after  first
       deleting all current records in the Special category on the palm:
	      pilot-addresses -c Special -d Special -r addrbook.csv

SEE ALSO

       pilot-link(7)

KNOWN BUGS

       pilot-addresses has no known bugs.

REPORTING BUGS

       Report bugs at http://bugs.pilot-link.org/

AUTHOR

       pilot-addresses originally written by Kenneth Albanowski, manual page was written by Robert Wittig <bob.wittig@gt.org>.

Free Software Foundation				    Palm Computing Device Tools 					pilot-addresses(1)
All times are GMT -4. The time now is 06:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy