Add additional numbers to file Post: 302400399

Sponsored Content

Top Forums Shell Programming and Scripting Add additional numbers to file Post 302400399 by devtakh on Wednesday 3rd of March 2010 05:54:42 AM

03-03-2010

Registered User

Try this: easy to understand. "file" is your input file.

Code:

#!/bin/sh

while read line
do
newstr=`echo $line | awk '{print $1}' | sed 's/"//g'`
day=`echo $newstr | cut -d "/" -f2`
month=`echo $newstr | cut -d "/" -f1`
year=`echo $newstr | cut -d "/" -f3`

timestr=`echo $line | awk '{print $2}'`
time_ind=`echo $line | awk '{print $3}' | cut -c 1-2`
hour=`echo $timestr | cut -d ":" -f1 `
min=`echo $timestr | cut -d ":" -f2 `
sec=`echo $timestr | cut -d ":" -f3 `

if [ "${time_ind}" == "PM" ]; then
   new_hour=$(( $hour + 12 ))
else
  new_hour=$hour
fi

if [ $day -lt 10 ];then
  new_day=`echo "0$day"`
else
  new_day=$day
fi

if [ $month -lt 10 ]; then
  new_month=`echo "0$month"`
else
  new_month=$month
fi

part_str=`echo $line | awk '{print substr($0,index($0,"M\"")+ 2)}'`
echo "\"$new_month/$new_day/$year $new_hour:$min:$sec\"$part_str"

done < file

cheers,
Devaraj Takhellambam

devtakh

View Public Profile for devtakh

Find all posts by devtakh

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add leading zeroes to numbers in a file

Hello, I am (trying) to write a script that will check to see how many users are logged on to my machine, and if that number is more than 60 I need to kill off all the oldest sessions that are over 60. So far I have been able to check how many users are on and now I am at the part where I have to...

2. Shell Programming and Scripting

how to add line numbers in text file

Hi all How to add line numbers in text file.. ex abcd cdef result 1. abcd 2. cdef thx in advance

3. AIX

How to add/remove additional DNS and IP to AIX

Hello, How to add/remove additional DNS and IP to AIX ? I wanted to add 3 more new DNS and IP addresses to existing AIX 5.2.

4. Shell Programming and Scripting

Add numbers in a file

Hello, How to add numbers that are read from a file /tmp/test The content of the file look like 1234 234 432 1235 123 I read the file content in a for loop f=/tmp/test for i in `cat $f` do . . done Santhosh

5. UNIX for Dummies Questions & Answers

Add floating point numbers from file

How do I use bash to add all the floating point numbers saved in a file like this? 490.47 244.61 263.07 131.59 246.81 115.20

6. Shell Programming and Scripting

add a additional column in csv file

Thanks for allwoing me to discuss in this forum GIVEN BELOW A simple shell script which will ask for the user to input a PC name and it will produce the output in CSV with the PC name #! /bin/bash read -p "enter the PC name :" pc #checking for netstat report netstat -pant |sed '1,2d'...

7. Shell Programming and Scripting

How to add line numbers (multiples of 5: 0,5,10,15,20) to a text file?

Hi, I need to number the lines in my text file. I know how to do this with standard numbering (1,2,3,4, etc) but I need to count in multiples of 5, beginning 0,5,10,15... example existing file: abcd efg hijklm nopqrs desired output 0 abcd 5 efg 10 hijklm 15 ...

8. AIX

Add additional swap place on AIX server

Can anyone help me the detailed procedure and commands to follow to add additional swap on aix server . My system shows following as of now , #lsattr -E -l sys0 -a realmem realmem 13893632 Amount of usable physical memory in Kbytes False #pstat -s PAGE SPACE: USED PAGES FREE...

9. Shell Programming and Scripting

awk to extract multiple values from file and add two additional fields

In the attached file I am trying to use awk to extract multiple values and create the tab-delimited desired output. In the output R_Index is a the sequential # and Pre_Enrichment is defaulted to .. I can extract from the values to the side of the keywords, but most are above and I can not...

10. Shell Programming and Scripting

find -exec How to add additional parameter when calling a funtion

Hello Current working script is : # # my_script BEGIN # function a_function { FIRST_PARAM="$1" DO_SOMETHING "$FIRST_PARAM" } export -f a_function START_HERE="/home/some_user/Documents" find $START_HERE" -exec bash -c 'a_function "$0" ' {} \;

LEARN ABOUT PHP

gregoriantojd

GREGORIANTOJD(3)							 1							  GREGORIANTOJD(3)

gregoriantojd - Converts a Gregorian date to Julian Day Count

SYNOPSIS

       int gregoriantojd (int  $month, int  $day, int  $year)

DESCRIPTION

	Valid Range for Gregorian Calendar 4714 B.C. to 9999 A.D.

	Although  this	function  can  handle  dates all the way back to 4714 B.C., such use may not be meaningful. The Gregorian calendar was not
       instituted until October 15, 1582 (or October 5, 1582 in the Julian calendar). Some countries did not accept it until much later. For exam-
       ple,  Britain  converted in 1752, The USSR in 1918 and Greece in 1923. Most European countries used the Julian calendar prior to the Grego-
       rian.

PARAMETERS

	      o $month
		- The month as a number from 1 (for January) to 12 (for December)

	      o $day
		- The day as a number from 1 to 31

	      o $year
		- The year as a number between -4714 and 9999

RETURN VALUES

	The julian day for the given gregorian date as an integer.

EXAMPLES

       Example #1

	      Calendar functions

	      <?php
	      $jd = GregorianToJD(10, 11, 1970);
	      echo "$jd
";
	      $gregorian = JDToGregorian($jd);
	      echo "$gregorian
";
	      ?>

SEE ALSO

       jdtogregorian(3), cal_to_jd(3).

PHP Documentation Group 													  GREGORIANTOJD(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add leading zeroes to numbers in a file

Discussion started by: raidzero

2. Shell Programming and Scripting

how to add line numbers in text file

Discussion started by: suryanarayana

3. AIX

How to add/remove additional DNS and IP to AIX

Discussion started by: balareddy

4. Shell Programming and Scripting

Add numbers in a file

Discussion started by: mvsanthosh