06-22-2010
date field manipulation
I have a data file. Seperated by "|". The 19 th filed is a date field that occurs like this
11/02/2001
i need to convert into the below format
2001-11-02
for e.g..
i/p
Quote:
1|147431|3284924|Superliner|1652382|765x125||Delta flight|1 x 1 Default Ad, 34|Superliner 765x125|ion|rt|rt|332|0|0.0|Clicks|05/07/2010|0|332|0|0|Y
o/p should be
Quote:
1|147431|3284924|Superliner|1652382|765x125||Delta flight|1 x 1 Default Ad, 34|Superliner 765x125|ion|rt|rt|332|0|0.0|Clicks|2010-05-07|0|332|0|0|Y
can somebody throw some light
I need to do this for all records in the file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
It sounds so easy to do.
I have a file thats laid out like this..
number text text text text (etc about 15 times with various text fields)
I want to take the first field, "number", subtract 100 from it, and then put it back in the file. a simple little manipulation of the first field in... (4 Replies)
Discussion started by: LordJezo
4 Replies
2. Shell Programming and Scripting
I need to achieve the following.....I seached the forum but could not find it...
This is I have in a file...
"CH","TIA","10/27/2006",000590
I need the date in the third field to be attached to fileas 20061027_test.txt
How do I do it. (6 Replies)
Discussion started by: mgirinath
6 Replies
3. Shell Programming and Scripting
HI,
I'm comparing my file date with the system date and if both the dates are equal I'm doing some operation. I use two variables for these two dates. I use the following command in my query. if ....
But here the current date $cd shows 01 and filedate $fdate shows 1. The file is created on 1 of ... (6 Replies)
Discussion started by: pstanand
6 Replies
4. Shell Programming and Scripting
Hi Gurus,
How to minus 15 minuets from current system time.
For example if current time is " Wed Oct 14 12:12:38 BST 2009", i need "Wed Oct 14 11:57:38 BST 2009"
Thanks (2 Replies)
Discussion started by: kumarmani
2 Replies
5. Shell Programming and Scripting
How can i print a future time, so i get current time by date "+%H:M" but how can i say add 20 minutes to the current time and display as I have just done for current time. (1 Reply)
Discussion started by: kelseyh
1 Replies
6. Shell Programming and Scripting
I have a file with a field containing the following:
"7/3/2009 7:07:12 PM","xxxx"
I need to be able to split this field up into two into a different format with the time being converted into 24 hour:
so that i can get the following:
"20090307","19:07:12","xxxx" (8 Replies)
Discussion started by: Pablo_beezo
8 Replies
7. Shell Programming and Scripting
In my shell script I take date as a input parameter from command line in the format "21 Oct 2011" which would be
date +'%d %b %Y'
Now i need to do two things here.
1) Validate the date entered by user
2) Calculate yesterday's date from the input. So in this case it should be: "20 Oct 2011"... (9 Replies)
Discussion started by: davidtd
9 Replies
8. Shell Programming and Scripting
I have a comma separated file containing numbers, I would like to read the file and divide each number by 1024 and create an output file.
Input file :
50312.00,3434.05, ,3433.34,124344.00,434343.00, , ,
Output file:
49.13,3.35,3.35,0,12.05,424.16,0,0
Please click this link: How to... (2 Replies)
Discussion started by: inditopgun
2 Replies
9. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
10. Shell Programming and Scripting
Hallo Team
I can perform the task manually but i would like to automate this process. ok here goes. I have a perl script which runs every Wednesday every week and the name of the script is check_19.pl
This is how the script looks like :
#!/usr/bin/perl -w
#use strict;
use DBI;
#... (1 Reply)
Discussion started by: kekanap
1 Replies
LEARN ABOUT DEBIAN
ppmtopgm
ppmtopgm(1) General Commands Manual ppmtopgm(1)
NAME
ppmtopgm - convert a portable pixmap into a portable graymap
SYNOPSIS
ppmtopgm [ppmfile]
DESCRIPTION
Reads a portable pixmap as input. Produces a portable graymap as output. The output is a "black and white" rendering of the original
image, as in a black and white photograph. The quantization formula used is .299 r + .587 g + .114 b.
Note that although there is a pgmtoppm program, it is not necessary for simple conversions from pgm to ppm , because any ppm program can
read pgm (and pbm ) files automatically. pgmtoppm is for colorizing a pgm file. Also, see ppmtorgb3 for a different way of converting
color to gray. And ppmdist generates a grayscale image from a color image, but in a way that makes it easy to differentiate the original
colors, not necessarily a way that looks like a black and white photograph.
QUOTE
Cold-hearted orb that rules the night
Removes the colors from our sight
Red is gray, and yellow white
But we decide which is right
And which is a quantization error.
SEE ALSO
pgmtoppm(1),ppmtorgb3(1),rgb3toppm(1),ppmdist(1),ppm(5),pgm(5)
AUTHOR
Copyright (C) 1989 by Jef Poskanzer.
10 April 2000 ppmtopgm(1)