Looks at the most efficient way to add up the column of data based off of the rows.
Random data
Name-Number-ID
Sarah-2.0-15
Bob-6.3-15
Sally-1.0-10
James-1.0-10
Scotty-10.7-15
So I would select all those who have ID = 15 and then add up total number
read - p "Enter ID number" Num
... (3 Replies)
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 Experts,
I am trying to add one variable value as the first value in a file speparated by "" (space) delimiter. Can you please let me know how I can do this using bash script.
Following is my file.
1635 ABCD 3m9ka COMPLETE
0526 AJAY 3m1da COMPLETE
0419 INDIA 3m3zi INCOMPLETE
The... (3 Replies)
hi all Please assist i need to add current date as data to load to a database:
the script is as follow:
#!/bin/ksh
DIR=/export/home/yani_m/scripts/scrip_out_put/
DIR2=/export/home/yani_m/scripts/scrip_out_put/calc/
Date=$1
File22="disk_"$Date
Server=$2
iofiles=$DIR"/*"$Date"*_Ynr.dat"... (4 Replies)
Hi,
I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates.
NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Hi
I have file with number status and date1 and date1 field,
want add a column today between column date1 and date2.
file1.txt
number status date1 date2
===== ==== === =====
34567 open 27/06/13 28/06/13
45678 open 27/06/13 28/06/13
43567 open 27/06/13 28/06/13 ... (1 Reply)
Tangram::Type::TimeAndDate(3pm) User Contributed Perl Documentation Tangram::Type::TimeAndDate(3pm)NAME
Tangram::Type::TimeAndDate - map date & time fields
SYNOPSIS
use Tangram;
# any of:
use Tangram::Type::Date; # RAW - use with caution
use Tangram::Type::Time;
use Tangram::Type::Date::Cooked; # pure ISO-8601
use Tangram::Type::Date::DateTime;
use Tangram::Type::Date::Manip;
use Tangram::Type::Date::TimePiece;
Tangram::Schema->new(
classes => {
NaturalPerson => {
fields => {
rawdatetime => [ qw( birth death ) ],
rawdate => [ qw( depart return ) ],
rawtime => [ qw( breakfast lunch dinner ) ],
cookeddatetime => [ qw( cooked ) ],
dmdatetime => [ qw( datemanip ) ],
timepiece => [ qw( fob ) ],
datetime => [ qw( bloat ) ],
DESCRIPTION
These classes are responsible for mapping strings to SQL date or time types. These classes are not imported by Tangram.pm, thus they must
be explicitly imported via a "use" directive.
The three typetags "rawdate", "rawtime" and "rawdatetime" are for mapping strings to SQL date/time types, for databases that differentiate
between "dates" and "times". 'Raw' means that Tangram doesn't attempt to interpret the strings, it merely passes them down to DBI.
"cookeddatetime" is like "rawdatetime" except that the date is converted from the DBMS format to ISO-8601 in the form :
YYYY-MM-DDTHH:MM:SS
for example:
2004-12-25T13:14:15
Other modules then further cook this ISO date into an object as is the convention for a particular module. This only works with back-ends
that allow per-connection settings for the default date format, such as Tangram::Driver::Oracle.
On the way back out, the date is converted back to the DBMS format. This is achieved via vendor-specific functions mentioned in "Tan-
gram::Relational".
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
* col
* sql
"col" sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Over-
ride if the field name is not an acceptable SQL column name.
"sql" sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings,
'INT NULL' for ints and 'REAL NULL' for reals.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.
perl v5.8.8 2006-03-29 Tangram::Type::TimeAndDate(3pm)