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

file2dgr

FILE2DGR(1)							  DGR executables						       FILE2DGR(1)

NAME

       file2dgr - DGR transmission test program

SYNOPSIS

       file2dgr remoteHostName fileName [nbrOfCycles]

DESCRIPTION

       file2dgr uses DGR to send nbrOfCycles copies of the text of the file named fileName to the dgr2file process running on the computer
       identified by remoteHostName.  If not specified (or if less than 1), nbrOfCycles defaults to 1.	After sending all lines of the file,
       file2dgr sends a datagram containing an EOF string (the ASCII text "*** End of the file ***") before reopening the file and starting
       transmission of the next copy.

       When all copies of the file have been sent, file2dgr prints a performance report:

	       Bytes sent = I<byteCount>, usec elapsed = I<elapsedTime>.

	       Sending I<dataRate> bits per second.

EXIT STATUS

       0   file2dgr has terminated.

FILES

       No configuration files are needed.

ENVIRONMENT

       No environment variables apply.

DIAGNOSTICS

       Diagnostic messages produced by file2dgr are written to the ION log file ion.log.

       Can't open dgr service.
	   ION system error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

       Can't open input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       Can't acquire DGR working memory.
	   ION system error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

       Can't reopen input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       Can't read from input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       dgr_send failed.
	   ION system error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

BUGS

       Report bugs to <ion-bugs@korgano.eecs.ohiou.edu>

SEE ALSO

       file2dgr(1), dgr(3)

perl v5.14.2							    2012-05-25							       FILE2DGR(1)