How can I apply 'date' command to specific columns, in a BASH script?
Hi everyone,
I have a situation in which I have multiple (3 at last count) date columns in a CSV file (, delim), which need to be changed from:
January 1 2017 (note, no comma after day)
to:
YYYY-MM-DD
So far, I am able to convert a date using: date --date="January 12, 1990" +%Y-%m-%d
However, I need to read a specific column in the CSV, then replace what's there with the new format. It doesn't matter which commonly used GNU utility I use, I just need to do it.
So far, I have been trying to write an AWK function in a BASH shell script to do it, but I'm completely lost.
Can anyone offer suggestions on the easiest way to accomplish this from within a BASH script? The attached sample.txt gives an idea of what the data looks like, only greatly reduced. The really data has about 3000 rows and 35 columns.
Hi all,
I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
I'm a newbie in AIX, i want to make a script for grep any lines with date bellow 20
PRINT0089-88615 data1 3072 Mon Dec 19 17:53:49 WITA 2011
PRINT0089-88616 data1 4096 Mon Dec 19 17:53:49 WITA 2011
PRINT0089-88618 data1 5120 Mon Dec 19... (7 Replies)
Hi
I need to find the list of files in a directory and to do some specific operations based on the type of files.
suppose in a directory am having .dat , .log, .err, .rej file types. i need to filter out .dat and .log only which are older than six months.
i used the below query but the... (2 Replies)
Hi All,
I have below perl script which writes xml from .xls file.
Now i want to add below two conditions in this script :
1. to check if the the input .xls file has ony two columns , if more tahn two columns then script should pop up an error.
2. If there are two columns , then first column... (4 Replies)
Hi All
I have a file which has five columns in each rows.
cat file.txt
a|b|c|d|e
1|2|3|4|5
a1|a2|a3|a4|a5
.
.
.
I need to make sure that there are no less than five or more than five columns (in all the rows) by mistake. I tried this :
cat file.txt | awk 'BEGIN{FS="|"};{print... (3 Replies)
In the bash below I am asking the user for a panel and reading that into bed. Then asking the user for a file and reading that into file1.Is the grep in bold the correct way to apply the selected panel to the file? I am getting a syntax error. Thank you :)
... (4 Replies)
Hello,
I have a requirement to apply hashing algorithm on flat file on one or more columns dynamically based on header
sample input file
ID|NAME|AGE|GENDER
10|ABC|30|M
20|DEF|20|F
say if i want multiple columns based on the header example id,name or id,age or name,gender and hash and... (13 Replies)
Discussion started by: mkathi
13 Replies
LEARN ABOUT DEBIAN
stripchart
STRIPCHART(5) File Formats Manual STRIPCHART(5)NAME
stripchart - draws diagrams from data with PHP
SYNOPSIS
The script is expected to be called as a CGI script but also works from the command line.
DESCRIPTION
Stripchart prepares a series of diagrams directly from raw data. It is handy for web pages that need some graphics without too much over-
head.
OPTIONS -i input FILE
name of input data file (mandatory)
-o output FILE
name of output .gif file (default: STDOUT)
-O output FILE
name of output .gif file, also dumps to STDOUT
-f from TIME
stripchart with data starting at TIME (default: 24 hours ago)
-t to TIME
stripchart with data ending at TIME (default: now)
-r range RANGE
stripchart data centered around "from" time the size of RANGE (overrides -t)
-l last LINES
stripchart last number of LINES in data file (overrides -f and -t and -r)
-T title TITLE
title to put on graphic (default: FILE RANGE)
-x column X
time or "x" column (default: 2)
-y column Y
value or "y" column (default: 3)
-Y column Y'
overplot second "y" column (default: none)
-b baseline VALUE
overplot baseline of arbitrary value VALUE
-B baseline-avg
overrides -b, it plots baseline of computed average
-d dump low VALUE
ignore data less than VALUE
-D dump high VALUE
ignore data higher than VALUE
-v verbose
puts verbose runtime output to STDERR
-L log makes y axis log scale
-c colors "COLORS"
set gnuplot colors for graph/axisnts/data (default: "xffffff x000000 xc0c0c0 x00a000 x0000a0 x2020c0" in order: bground, axisnts,
grids, pointcolor1,2,3)
-C cgi output CGI header to STDOUT if being called as CGI
-s stats
turn extra plot stats on (current, avg, min, max)
-j julian times
time columns is in local julian date (legacy stuff)
-V version
print version number and exit
-h help
display this help
NOTES
* TIME either unix date, julian date, or civil date in the form:
YYYY:MM:DD:HH:MM (year, month, day, hour, minute)
If you enter something with colons, it assumes it is civil date
If you have a decimal point, it assumes it is julian date
If it is an integer, it assumes it is unix date (epoch seconds)
If it is a negative number, it is in decimal days from current time
(i.e. -2.5 = two and a half days ago)
* All times on command line are assumed to be "local" times
* All times in the data file must be in unix date (epoch seconds)
* RANGE is given in decimal days (i.e. 1.25 = 1 day, 6 hours)
* if LINES == 0, (i.e. -l 0) then the whole data file is read in
* columns (given with -x, -y, -Y flags) start at 1
* titles given with -T can contain the following key words which will
be converted:
FILE - basename of input file
RANGE - pretty civil date range (in local time zone)
the default title is: FILE RANGE
AUTHORS
Matt Lebofsky
2.21 November 2002 STRIPCHART(5)