Changing the date format


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Changing the date format
# 1  
Old 05-08-2011
Java Changing the date format

Hi All,

I am new to this forum, could any one help me out in resolving the below issue.


Input of the flat file contains several lines of text for example find below:

5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1
5022090,4,1,6648,88,,,,,4/1/2011 0:00,Z,,1

output:

5022090,2,4,7154,88,,,,,01-Apr-2011,Z,L,2
5022090,3,1,6648,88,,,,,01-Apr-2011,Z,,1
5022090,4,1,6648,88,,,,,01-Apr-2011,Z,,1


I am using SunOS.


Information:

This is for one particular flat file while in other flat files the date field may contain at some other column the column of the date field is not common to all the flat files.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing date format

how do i change the following to show me what the date was 7 days ago? date +%Y-%m-%d (1 Reply)
Discussion started by: SkySmart
1 Replies

2. Shell Programming and Scripting

Changing Date Format

How can i make the date command output yesterday's date, current date and the date 4 days ago, in the following format: 2012-10-03 code: date +% ???? (3 Replies)
Discussion started by: SkySmart
3 Replies

3. Shell Programming and Scripting

Changing the date format

Hi all, I have a file with below data af23b|11-FEB-12|acc7 ad23b|12-JAN-12|acc4 as23b|15-DEC-11|acc5 z123b|18-FEB-12|acc1 I need the output as below:-(date in yyyymmdd format) af23b|20120211|acc7 ad23b|20120112|acc4 as23b|20111215|acc5 z123b|20120218|acc1 Please help me on this.... (7 Replies)
Discussion started by: gani_85
7 Replies

4. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

5. Shell Programming and Scripting

Changing Date format

How to change a date stored in a variable to YYYYMMDD. Variable output is in DD-MON-YY,required format is 'YYYYMMDD' Thanks, Sud (1 Reply)
Discussion started by: sud
1 Replies

6. Shell Programming and Scripting

Changing date format

Hi, I have a column in a table of Timestamp datatype. For Example : Var1 is the column 2008-06-26-10.10.30.2006. I have Given query as date(var1) and time (var1) I got the file as in the below format : File1: Col1 Col2 2008-06-02|12.36.06 2008-06-01|23.36.35 But the problem is... (7 Replies)
Discussion started by: manneni prakash
7 Replies

7. Post Here to Contact Site Administrators and Moderators

changing the format of date

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (1 Reply)
Discussion started by: nasirgondal
1 Replies

8. UNIX for Dummies Questions & Answers

Changing the format of date

Hi, There are lots of threads about how to manipulate the date using date +%m %....... But how can I change the default format of the commad date? $ date Mon Apr 10 10:57:15 BST 2006 This would be on fedora and SunOs. Cheers, Neil (4 Replies)
Discussion started by: nhatch
4 Replies

9. Shell Programming and Scripting

Changing date format

Hi, Is there any way to change one date format to another ?? I mean I have a file having dates in the format (Thu Sep 29 2005) ... and i wud like to change these to YYYYMMDD format .. is there any command which does so ?? Or anything like enum which we have in C ?? Thanks in advance, ... (5 Replies)
Discussion started by: Sabari Nath S
5 Replies

10. Shell Programming and Scripting

Changing the date format

Hi, I know there is a Q/A section and lots of posts regarding date command here. I am sorry to start a new thread. I am very new to shell scripting (actually i am working on my first program), so please forgive my ignorance. I could not find an answer to my problem else where so i posted it... (10 Replies)
Discussion started by: Dream86
10 Replies
Login or Register to Ask a Question
SWISS::Entry(3pm)					User Contributed Perl Documentation					 SWISS::Entry(3pm)

Name
       SWISS::Entry

Description
       Main module to handle SWISS-PROT entries. One Entry object represents one SWISS-PROT entry and provides an API for its modification.

       The basic concept is the idea of lazy parsing. If an Entry object is created from the entry in flat file format, the text is simply stored
       in the private text attribute of the entry object. The member objects of the entry are only created if they are dereferenced.

Example
       This minimum program reads entries from a file in SWISS-PROT format and prints the primary accession number for each of the entries.

Attributes
       The following attributes represent member objects. They can be accessed like e.g. $entry->IDs

       IDs ID line object

       ACs
       DTs
       DEs
       GNs
       OSs
       OCs
       Refs
	   The reference block object

       CCs
       KWs
       DRs
       FTs
       Stars
	   Object for the annotator's section stored in the ** lines.

       SQs The sequence object.

Methods
       new Return a new Entry object

       initialize
	   Initialise an Entry object and return it.

       update [force]
	   Update an entry. The content of the member objects is written back into the private text attribute of the entry if necessary. If $force
	   is true, an update of all member objects is forced.

       reformat
	   Reformat all fields of an entry.

       fromText $text [, $fullParse[, $removeInternalComments]]
	   Create an Entry object from the text $text. If $fullParse is true, the entry is parsed at creation time. Otherwise the individual line
	   objects are only created if they are dereferenced. If $removeInternalComments is true, wild comments and indentation will be removed
	   from the text before the parsing is done. [NOTE: wild comments are lines starting with a double asterisk located outside the Stars
	   section, and indented lines are lines starting with spaces. Both are used internally by SWISS-PROT annotators during their work and
	   excluded from internal and external releases.]

       toText [$insertInternalComments]
	   Return the entry in flat file text format. If internal comments and indentation have been removed as specified in the parameters to
	   fromText(), you may wish to reinsert them in the text output by setting $insertInternalComments to true.

       toFasta
	   Return the entry in Fasta format.

       equal
	   Returns True if two entries are equal, False otherwise

       The following methods are provided for your convenience. They are shortcuts for methods of the individual line objects.

       ID  Returns the primary ID of the entry.

       AC  Returns the primary AC of the entry.

       SQ  Returns the sequence of the entry.

       EV  Returns the EV (evidence) object of an entry. SWISS-PROT internal method.

   Data access methods
       text
	   Returns the current text of the entry.  Quick and dirty! No update of the text is performed before.

       database_code
	   Is it a SWISS-PROT, TREMBL or TREMBLNEW entry?  database_code tries to find it out.	Return values are S for SWISS-PROT, 3 for TREMBL,
	   Q for TREMBLNEW, ? for unknown.

       isFragment
	   Returns true if the DE line indicates a fragment, or of the entry contains a NON_CONS or NON_TER feature.

       isCurated
	   Returns 1 if the entry is a curated entry, 0 otherwise.

	   SWISS-PROT internal use only.

perl v5.10.1							    2008-07-16							 SWISS::Entry(3pm)