Keeping padding in a date field Post: 302275832

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Arrange date in a field

Hi all, If I have a flat file ID|Location|Date|Hostname|Age|Sex 1|SFO|06/02/24 12:12:34|hawkeye|35|M 2|LAX|06/02/24 13:12:35|sf49ers|30|M 3|OAK|06/02/25 11:12:36|goraiders|27|F 4|PIT|06/02/25 12:12:37|steeler|35|M How can I create an output 1|SFO|02/24/2006 12:12:34|hawkeye|35|M...

2. Shell Programming and Scripting

handling date field

Hi, Is there any way we could change the date format listed below... date I get is 03302007 (MMDDYYYY) I need to change it to 20070330 (YYYYMMDD) Thanks.

3. Shell Programming and Scripting

CSV formatting with prefixing, appending and padding field

Hi I have a very large csv file with some hundreds of thousands of rows of data. The data is in the following format: Up to four alpha numeric characters for the first word. This is either set as 2 characters followed by 2 spaces, or as a single 4character word. This is then followed by an 8...

4. Shell Programming and Scripting

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 o/p should be can somebody throw some light

5. UNIX for Advanced & Expert Users

change field 2 date format

from this input WEBELSOLAR,29122009,1:1 WIPRO,15062010,2:3 ZANDUREALT,18012007,1:3 i want output as WEBELSOLAR,20091229,1:1 WIPRO,20100615,2:3 ZANDUREALT,20070118,1:3 basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format

6. Shell Programming and Scripting

Replace date value with another value keeping all as is

Hi forum. How do I change the following date value with another value (while keeping the rest of the line) using sed? The date values can change so I need a general sed command to change the date value within the first quotation marks only. Date values will be coming from 2 different files....

7. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"...

8. Shell Programming and Scripting

Sort, sed, and zero padding date column csv bash scripting

Hello people, I am having problem to sort, sed and zero padding of column in csv file. 7th column only. Input of csv file: 1,2,3,4,5,6,4/1/2010 12:00 AM,8 1,2,3,4,5,6,3/11/2010 9:39 AM,8 1,2,3,4,5,6,5/12/2011 3:43 PM,8 1,2,3,4,5,6,12/20/2009 7:23 PM,8 Output:...

9. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

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...

LEARN ABOUT DEBIAN

nnstats

NNSTATS(1m)															       NNSTATS(1m)

NAME

       nnstats - display nnmaster collection and expire statistics

SYNOPSIS

       nnstats [ -lt ] [ -d month day ] [ -m month ] [ logfile ]...

DESCRIPTION

       nnstats	will  extract  the collection (C) and expiration (X) entries from the log file and calculate total and average number of articles,
       groups and elapsed time per day, per month, or for the duration of the whole log file.

       Normally only a summary for the specified period is printed.  If -l is specified, the statistics  for  each  day  in  the  period  is  also
       printed, and if -t is specified the summary is not printed.

       Normally the statistics is collected for all days in the log files (or the current log file if one is not specified).

       If  "-m	month" is specified, the statistics for that month is calculated.  The month is specified in normal date notation, i.e. a capital-
       ized three letter abbreviation like Jan, Feb, ...

       If "-d month day" is specified, the statistics for that date only is calculated and printed.

FILES

       ../Log	The log file

SEE ALSO

       nn(1), nnusage(1M), nnadmin(1M), nnmaster(8)

NOTES

       If nnmaster is run with options -LCX, nnstats will not work, because the necessary entries are not written to the log file.

AUTHORS

       Mark Moraes <moraes@csri.toronto.edu>
       Kim F. Storm <storm@texas.dk>

4th Berkeley Distribution					    Release 6.6 						       NNSTATS(1m)