Generate tabular data based on a column value from an existing data file
Hi,
I have a data file with :
I need to find the first occurring date and the last occurring date for a particular value in column 4 for each combination of column 2 and 3
For example the output from above data should be:
because the value (column 4)=98955 for (column 2)=1 and (column 3)=1 first occurs on date 01/28/2012 and last occurs on date 01/29/2012, after which on 01/30/2012 it changes to 98896,so a new row is added.When a value is the last value in the file, the last occurance date is 99/99/9999.
Not sure whether i could make it clear but is unix shell scripting(with awk maybe) the best way to achieve this or does this need something like perl ?
Last edited by Franklin52; 01-18-2013 at 04:01 AM..
Reason: Please use code tags for data and code samples
Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.
E.g : username empid
------------------------
sri 123
to
username,empid
sri,123
Thanks,
Hema:confused: (2 Replies)
Hi all,
I need help to add additional data from file2 to existing data in file 1 using awk, sed or perl. the ID in file 1 should match against field $3 in file2
file1
#this is a new game
ID HR_1
BASE1 30
BASE2 37
DETAIL No
TYPE L
@@
ID HR_10
BASE1 6030
BASE2 ... (4 Replies)
Hi All,
I need to develop a shell script which does sanity check of a data file, as below.
1. For DATE columns, it should check if date is given in proper format or not? For example, if format of date is expected as DD-MON-YYYY HH24:MI:SS and we received the date in formation like DDMMYYYY HH24,... (1 Reply)
Hi All
I need to add a column on my existing data file. I know similar posts are there but none of them were meeting my requirement. My input is
1.20 3.44 4.88
5.11 4.99 3.22
1.89 3.89 2.90
Desired output
1 1.20 3.44 4.88
2 5.11 4.99 3.22
3 1.89 3.89 2.90
I will... (2 Replies)
Hi all,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (3 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Hi,
I have a file pk.txt which has pk data in following format
TableName | PK
Employee | id
Contact|name,country
My Output should be
Employee | t1.id=s.id
Contact| t1.name=s.name AND t1.country=s.country
I started of like this:
for LIST in `cat pk.txt` do... (5 Replies)
We have the data looks like below in a log file.
I want to generat files based on the string between two hash(#) symbol like below
Source:
#ext1#test1.tale2 drop
#ext1#test11.tale21 drop
#ext1#test123.tale21 drop
#ext2#test1.tale21 drop
#ext2#test12.tale21 drop
#ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
LEARN ABOUT OSX
softwareupdate
softwareupdate(8) BSD System Manager's Manual softwareupdate(8)NAME
softwareupdate -- system software update tool
SYNOPSIS
softwareupdate command [args ...]
DESCRIPTION
Software Update checks for new and updated versions of your software based on information about your computer and current software.
Invoke softwareupdate by specifying a command followed by zero or more args.
softwareupdate requires admin authentication for all commands except --list. If you run softwareupdate as a normal admin user, you will be
prompted for a password where required. Alternatively, you can run softwareupdate as root and avoid all further authentication prompts.
The following commands are available:
-l | --list
List all available updates.
-i | --install
Each update specified by args is downloaded and installed. args can be one of the following:
-r | --recommended
All updates that are recommended for your system. These are prefixed with a * character in the --list output.
-a | --all All updates that are applicable to your system, including those non-recommended ones, which are prefixed with a -
character in the --list output. (Non-recommended updates are uncommon in any case.)
item ... One or more specified updates. The --list output shows the item names you can specify here, prefixed by the * or -
characters. See EXAMPLES.
-d | --download
Each update specified by args is downloaded but not installed. The values of args are the same as for the --install command.
Updates downloaded with --download can be subsequently installed with --install, or through the App Store (as long as they remain
applicable to your system). Updates are downloaded to /Library/Updates, but are not designed to be installed by double-clicking
the packages in that directory: always use --install or the App Store to actually perform the install.
--ignore identifier ...
Manages the per-machine list of ignored updates. The identifier is the first part of the item name (before the dash and version
number) that is shown by --list. See EXAMPLES.
--reset-ignored
Clears the per-machine list of ignored updates.
--schedule on | off
Manages the per-machine automatic (background) check preference.
-h | --help
Print command usage.
EXAMPLES
The following examples are shown as given to the shell:
softwareupdate --list
Software Update Tool
Copyright 2002-2012 Apple Inc.
Finding available software
Software Update found the following new or updated software:
* MacBookAirEFIUpdate2.4-2.4
MacBook Air EFI Firmware Update (2.4), 3817K [recommended] [restart]
* ProAppsQTCodecs-1.0
ProApps QuickTime codecs (1.0), 968K [recommended]
* JavaForOSX-1.0
Java for OS X 2012-005 (1.0), 65288K [recommended]
sudo softwareupdate --install JavaForOSX-1.0
Software Update Tool
Copyright 2002-2012 Apple Inc.
Finding available software
Downloading Java for OS X 2012-005
Downloaded Java for OS X 2012-005
Installing Java for OS X 2012-005
Done with Java for OS X 2012-005
Done.
sudo softwareupdate --ignore JavaForOSX
Ignored updates:
(JavaForOSX)
sudo softwareupdate --schedule
Automatic check is on
Mac OS September 11, 2012 Mac OS