Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Transpose Datefield from rows to column + Print time diff
Top Forums Shell Programming and Scripting Transpose Datefield from rows to column + Print time diff Post 302718573 by spacebar on Friday 19th of October 2012 11:26:33 PM
Old 10-20-2012
This is one way:
Code:
$ cat t
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350

$ cat test.sh
while IFS="," read inDate jobName
do
  (( c+=1 ))
  if [[ $c -eq 1 ]]; then
    ts1=$inDate
  else
    s=$(( $(date -d "$inDate" +%s) - $(date -d "$ts1" +%s) ))
    printf "$inDate,$ts1,%02d:%02d:%02d" $((s/3600)) $((s%3600/60)) $((s%60))
    echo ",$jobName"
    c=0
  fi
done <t

$ test.sh
08/23/2012 12:36:14,08/23/2012 12:36:09,00:00:05,JOB_5340
08/23/2012 12:36:26,08/23/2012 12:36:22,00:00:04,JOB_5350

This User Gave Thanks to spacebar For This Post:
asnandhakumar
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk transpose rows to column

Need to transpose in awk rows to column like this: input: A1,6,5,4 3,2,1, A2,8,7,9,10,11,12,13,14 A3,1,2,3,5,7,8,9 A4,9,4,8,1,5,3, output: A1,1 A1,2 A1,4 ... A2,7 A2,8 ... A3,1 A3,2 ... A4,1 A4,3 (5 Replies)
Discussion started by: sdf
5 Replies

2. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

3. Shell Programming and Scripting

Transpose timestamp based on column values and calculate time difference

Hello Expert, I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom INPUT File ======== 08/23/2012 12:36:09 JOB_5340 08/23/2012 12:36:14 JOB_5340 08/23/2012... (2 Replies)
Discussion started by: asnandhakumar
2 Replies

4. Shell Programming and Scripting

awk to transpose preceding row to 1st column of next rows

Gurus: How can I transpose the output below to a format in which I can plot a graph to show VSZ memory usage by PIDs? stdout: Tue Jan 22 07:29:19 CUT 2013 42336296 1841272 java wilyadm 21889232 438616 jlaunch sidadm 42532994 414336 jlaunch sidadm Tue Jan 22 07:49:20 CUT 2013... (1 Reply)
Discussion started by: ux4me
1 Replies

5. Shell Programming and Scripting

Transpose Column of Data to Rows

I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows: NAME=BOB ADDRESS=COLORADO PET=CAT NAME=SUSAN ADDRESS=TEXAS PET=BIRD NAME=TOM ADDRESS=UTAH PET=DOG I would... (7 Replies)
Discussion started by: docdave78
7 Replies

6. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Discussion started by: sara.nowreen
3 Replies

7. Shell Programming and Scripting

Peel syntax for transpose rows into column

Dear all, Plz let me know syntax for transposing rows into column in perl, I am having 30 csv files which are merged into a single xls sheet. but i want to transpose each row into column in excel sheet in each tab (1 CSV = 1tab in xls sheet) example is as below ... (0 Replies)
Discussion started by: sagar_1986
0 Replies

8. Programming

To transpose rows to column in hadoop

Hi, i am having an HDFS file which is comma seperated, i need to transpose from rows to column only the header columns text.csv cnt,name,place 1,hi,nz 2,hello,aus I need cnt, name, place while using below command in hadoop getting the error hadoop fs -fmt -1 text.csv (0 Replies)
Discussion started by: rohit_shinez
0 Replies

9. Shell Programming and Scripting

Linux - Transpose rows into column

hello, I have a server that collect some performance statistics of 4 servers in the following input file : $ cat inputfile Time,A,Server1,KPI1,data1 Time,A,Server1,KPI2,data2 Time,A,Server1,KPI3,data3 Time,A,Server1,KPI4,data4 Time,A,Server1,KPI5,data5 Time,A,Server2,KPI1,data6... (9 Replies)
Discussion started by: capitain25
9 Replies

10. UNIX for Beginners Questions & Answers

How to transpose pieces of data in a column to multiple rows?

Hello Everyone, I am very new to the world of regular expressions. I am trying to use grep/sed for the following: Input file is something like this and there are multiple such files: abc 1 2 3 4 5 ***END*** abc 6 7 8 9 ***END*** abc 10 (2 Replies)
Discussion started by: shellnewuser
2 Replies

LEARN ABOUT DEBIAN

osd_cat

XOSD(1) 						      General Commands Manual							   XOSD(1)

NAME

       osd_cat - X on-screen file displayer

SYNOPSIS

       osd_cat [OPTION] [FILE]...
       osd_cat -b percentage|slider [OPTION]

DESCRIPTION

       Display FILE, or standard input, on X screen.

       -p, --pos=POS
	      This option tells osd_cat where to display the text. POS can be top, middle, or bottom. The default is top.

       -o, --offset=OFFSET
	      This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0.

       -A, --align=ALIGN
	      This option tells osd_cat where to display the text. ALIGN can be left, right or center. The default is left.

       -i, --indent=OFFSET
	      This option specifies the INDENT from the left of screen the text is displayed. The default is 0.

       -f, --font=FONT
	      This option specifies the FONT to be used for displaying the text. The default is fixed.

       -c, --color=COLOR
	      This option specifies the COLOR to be used for displaying the text. The default is red.

       -d, --delay=TIME
	      This option specifies the number of seconds the text is displayed. The default is 5 seconds.

       -l, --lines=LINES
	      This option specifies the number of LINES to scroll the display over. The default is 5.

       -s, --shadow=OFFSET
	      This option specifies the OFFSET of the text shadow. The default is 0, which means no text shadow is created.

       -S, --shadowcolour=COLOUR
	      This option specifies the COLOUR of the text shadow.  The default is black.

       -O, --outline=WIDTH
	      This option specifies the WIDTH of the text outline.  The default is 0, which is no outline.

       -u, --outlinecolour=COLOUR
	      This option specifies the COLOUR of the text outline.  The default is black.

       -a, --age[=SCROLL_AGE]
	      This  option  affects  screen  redrawing.  If SCROLL_AGE seconds pass before a new line is ready (for example, you're reading from a
	      pipe), all lines are cleared at once instead of being scrolled off as new lines replace old lines. The default is 0.
	      When no SCROLL_AGE is explicitly given, the current value from DELAY is used.

       -w, --wait
	      This option also affects screen redrawing. When there is data ready to be put on screen, this option  will  cause  osd_cat  to  wait
	      until the display is clear. An alternative to scrolling.

       -b, --barmode=TYPE
	      Lets  you  display a percentage or slider bar instead of just text.  TYPE may be percentage or slider.  In this mode no text is read
	      from any file, but the following options can be used:

       -P, --percentage=PERCENTAGE
	      This option specified the position of the percentage / slider bar.  PERCENTAGE may be in the range from 0 to 100, the default is 50.

       -T, --text=TEXT
	      This option specifies an optional TEXT which gets displayed above the percentage bar.  The default is empty, so no  additional  text
	      is displayed.

       -h, --help
	      display help (which is often more up to date) and exit

       With no FILE, or when FILE is -, read standard input.

AUTHOR

       Martijn	van  de  Streek  <martijn@foodfight.org>,  Some  patching  done  by  Malcolm  Valentine  <farkit@iprimus.com.au>  and  Tim  Wright
       <tim@ignavus.net>.
       xosd was written by Andre Renaud <andre@ignavus.net> and is maintained by Tim Wright <tim@ignavus.net>

SEE ALSO

       More   information   on	 the   X   OSD	 Library   and	 its	author	  can	 be    found	on    http://www.ignavus.net/software.html
       <http://www.ignavus.net/software.html>

COPYRIGHT

       It is distributed under the GNU General Public License.

X OSD cat							   January 2001 							   XOSD(1)
All times are GMT -4. The time now is 09:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy