Sponsored Content
Top Forums Shell Programming and Scripting Date conversion in row while preserving rest of fields Post 302505649 by pchang on Thursday 17th of March 2011 01:48:20 PM
Old 03-17-2011
Date conversion in row while preserving rest of fields

Hi Forum.

I searched the forum for a solution but could not find an exact one to my problem.

I have some records in the file where I would like to convert the last date field to another format while preserving the rest of the other fields.

For example:
Code:
Found:
00000000|2011-Inactive-Segment|2|1|03/15/2011 0:00:00

Expected:
00000000|2011-Inactive-Segment|2|1|15-MAR-2011

Please help.

Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

column to row conversion with additional pattern

Hi there, I've an input file1 as follows: 1001 1002 1003 1004 1005 I would like to have an output file2 as follows: Numbers are 1001/ 1002/ 1003/ 1004/ 1005/ Any help is appreciated. (2 Replies)
Discussion started by: kbirde
2 Replies

2. Shell Programming and Scripting

To count distinct fields in a row

I have . dat file which contains data in a specific format: 0 3 892 921 342 1 3 921 342 543 2 4 817 562 718 765 3 3 819 562 717 761 i need to compare each field in a row with another field of the same column but different row and cont the... (8 Replies)
Discussion started by: Abhik
8 Replies

3. Shell Programming and Scripting

Identifying specific fields in a Row

Hi, I am new to UNIX. Can some one help me to solve the below. I have a requirement to to identify the specific fields in row and also some part of the field. In my file I have a record as sundra;10.44.48.65;10thstreet TCP packet out of state: First packet isn't SYN;telno:... (3 Replies)
Discussion started by: suneel.mekala
3 Replies

4. Shell Programming and Scripting

Julian date to Calendar date conversion

Hi all, I require to convert julian date to normal calander date in unix for eg julian date=122 now i want corresponding calander date ---------------------------------------- gr8 if give very small command/script and please explain the steps as well(imp) Thanks ... (3 Replies)
Discussion started by: RahulJoshi
3 Replies

5. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

6. Shell Programming and Scripting

complicated row to rows conversion

I have a file containing rows with the following format. Field1|Field2|Field3|data1:data data2:data data3:"dataA:data dataB:data" data4:data:data (and so on) I need to format the above row into multiple rows that look like this: Field1|Field2|Field3|data1|data ... (2 Replies)
Discussion started by: newreverie
2 Replies

7. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies

8. Shell Programming and Scripting

Row to Column conversion?

I have a text file with the geneIds separated by space in each line. The number Ids in lines are different. The file is like: abc qwe tyu ghj jkl dfg sdf cvb sdk fgh tyu uio iop tyu rty eru wer rty iop asd sdf dfg fgh zxc I want to format the file like: abc qwe tyu ghj jkl ... (7 Replies)
Discussion started by: sammy777
7 Replies

9. UNIX for Dummies Questions & Answers

[Solved] Uneven column to row conversion

Hi Unix Forum, I have a relatively easy question i suppose for which, however, until now i could not find a solution. I am working with a program that will give me an output file similar to the following: A 1 2 3 4 B 1 2 3 4 C 1 (9 Replies)
Discussion started by: Leander
9 Replies

10. Shell Programming and Scripting

Analyzing last 2 fields of 1 row and 3rd field of next row

I have the following script that will average the last two fields of each row, but im not sure how to include the 3rd field of the following row. An example of the analysis that I need to perform from the input - (66.61+58.01+54.16)/3 awk '{sum=cnt=0; for (i=13;i<=NF;i++) { sum+=$i; cnt++... (1 Reply)
Discussion started by: ncwxpanther
1 Replies
scan(1) 						      General Commands Manual							   scan(1)

NAME
scan - produce a one-line-per-message scan listing (only available within the message handling system, mh) SYNOPSIS
scan [+folder] [msgs] [options] OPTIONS
Directs scan to clear the screen. If the -clear switch is used and the output of scan is directed to a terminal, then scan consults the $TERM and $TERMCAP environmental variables to determine your terminal type in order to find out how to clear the screen prior to exiting. If the -clear switch is used and the output of scan is not directed to a terminal, then scan sends a formfeed prior to exiting. Re-formats the output of scan according to the instructions in the named file. The named formatfile must be in mh-format style; see mh-format(4) for more details. Re-formats the output of scan according to the instructions in the string given. The string must be in mh-format style; see mh-format(4) for more details. You must place the string argument to this command in double quotes ("). Produces a header line prior to the scan listing. The header line displays the name of the folder and the date and time. This can be suppressed using the -noheader option. Prints a list of the valid options to this command. Lists the output from scan in reverse order, from the highest message number to the lowest. The -noreverse option lists messages in the conventional way, from lowest to highest numbers. The -noreverse option is the default. Specifies the width of your screen, in columns. The defaults for this command are as follows: +folder defaults to the current folder msgs defaults to all -noheader -width defaults to the width of the terminal DESCRIPTION
The scan command produces a one-line-per-message listing of the messages in the current folder. You can scan a folder other than the current folder by using the +folder argument. You can use the msgs argument to produce a scan listing of a number of messages or a range of messages in the specified folder. You can also use scan in conjunction with a message sequence defined by mark or pick. See mark(1) for more information on sequences. Each scan line contains the message number, the date, the From: field, the Subject: field, and, if room allows, some of the body of the message. The current message is marked with a plus sign (+). The scan command actually reads each of the specified messages and parses them to extract the desired fields. If format errors are found in any of the messages during parsing, scan produces appropriate error messages. Because MH has been configured with the BERK option, scan has two additional options: -reverse and -noreverse. In addition, scan updates the MH context prior to starting the listing, so interrupting a long scan listing preserves the new context. The default configuration file that is supplied with MH has the BERK option enabled. If scan encounters a message without a Date: field, the date is filled in with the last write date of the message, and an asterisk (*) is appended. This is useful for identifying unsent message drafts. Unsent drafts are not usually allowed to contain a Date: field, and are consequently marked with an asterisk in scan listings. PROFILE COMPONENTS
Path: To determine your Mail directory Alternate-Mailboxes: To determine your mailboxes EXAMPLES
The following example produces a listing of messages 11 through 15 in the folder +inbox : % scan +inbox 11-15 11 18/01 ralph Project Plan Meeting Monday<<This 12 -21/01 johnson squash<<Thought i might postpone 13 21/01 smith@ultrixhost support from US during conversion 14 21/01 jjones@subone.dne new forum for discussion of mail 15+ 21/01 calvin@hobbes.uuc Re: new forum for discussion of m In this listing, the plus sign (+) on message 15 indicates that it is the current message. The hyphen (-) on message 12 indicates that you have replied to the message. It is produced by the -annotate option to repl; see repl(1) for more information. If there is sufficient room left on the line after the subject, scan fills the line with text from the body, preceded by <<, and terminated by >> if the body is suffi- ciently short. FILES
The user profile. SEE ALSO
inc(1), mark(1), pick(1), show(1), mh-format(4) scan(1)
All times are GMT -4. The time now is 06:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy