Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk work with time change in csv file
Top Forums Shell Programming and Scripting awk work with time change in csv file Post 302552707 by raghavendra.nsn on Monday 5th of September 2011 07:37:48 AM
Old 09-05-2011
awk work with time change in csv file
Hi,

i have csv input file looks like below

3rd field is date and time field i want to change it with user supplied date and time says
Code:
year=2011
		month=09
		day=05
		hour=11
                count=2

when count is say 10 then first ten records should pick and it should increment the second fields by 1 for each record. if user suplies count = 61
then second should increment upto 59 then minute should increment and second again should with 01.


HTML Code:
Event: "07709367129","12","2008/05/12-03-15-00.00",,"GBP",,,,,,,,"07709367129","000000000001234","0","100C",,,,,,,,,,,,,,,"822",,"Rj-aZlKEwBkAAADPAAAAIgACh1YAAAAA~2",,,
Event: "07709367129","12","2008/05/12-03-30-00.00",,"GBP",,,,,,,,"07709367129","07852306109","0","100C",,,,,,,,,,,,,,,"822",,"Rj-aiFKEwBkAAADPAAAAHgAChf8AAAAA~2",,,"00:

outut should look like below

Code:
Event: "07709367129","12","2011/09/05-11-00-00.00",,"GBP",,,,,,,,"07709367129","000000000001234","0","100C",,,,,,,,,,,,,,,"822",,"Rj-aZlKEwBkAAADPAAAAIgACh1YAAAAA~2",,,
Event: "07709367129","12","2011/09/05-11-00-01.00",,"GBP",,,,,,,,"07709367129","07852306109","0","100C",,,,,,,,,,,,,,,"822",,"Rj-aiFKEwBkAAADPAAAAHgAChf8AAAAA~2",,,"00:

if count is given 61 then

it should pick 61 records from file minute should start with 00 and second with 00 , 01 ..... 59 then minute should increment to 01:00 for 60 th record and 01:01 for 61 st



i have written awk code its not working as expected.

Code:
year=2011
                month=09
                day=05
                hour=11
                count=2
rm -f tt.tmp
com=$year/$month/$day-$hour-

min=00

i=0


awk ' BEGIN { FS=OFS="," } { x=$count ; for( i = 0; i <= x; i++ ) {$3="'$com'""'$min-'""$i"":00"
  print $0}}' tt >> tt.tmp



any rectification or any other thought ?


thanks,
Raghavendra
Last edited by radoulov; 09-05-2011 at 09:30 AM.. Reason: Code tags.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to change the file modification time of a file on nfs mount point

Hi I am accessing a file on nfs mounted device, after completing using of the file, i am tring to restore the access time and modification times of the file. So i got the previous modified time of the file using stat() function and trying to set the date and time for the file, To set these... (6 Replies)
Discussion started by: deepthi.s
6 Replies

2. Shell Programming and Scripting

Work CSV file with awk loop

I need to converts a CSV file from Format "A" into Format "B", where the first field is repeated in a loop with a counter. I'am quite sure that this is with AWK possible burt the "Forum Search Function" doesn't work at the moment. Format "A" A1;B1 ;B2 ;B3 A2;C1 ;C2 ;C3 ... (2 Replies)
Discussion started by: frieling
2 Replies

3. UNIX for Dummies Questions & Answers

How to work with fields of a csv file?

I need to insert data into a perticular field of a csv file, lets say second field. Can any one help me to do this? I found that we can do it with sed. can any one guide me to accomplish this? thanks in advance. (12 Replies)
Discussion started by: praveen_b744
12 Replies

4. UNIX for Advanced & Expert Users

Time validation in a csv file

Hi, Im having a hard time in creating a script with the following conditions below. I have a csv file generated which is updated every 5 mins and it contains a timestamp in it. for example: time data 00:00 1 00:05 0 00:10 6 00:15 3 however, there is a time that... (4 Replies)
Discussion started by: mdap
4 Replies

5. Shell Programming and Scripting

Strip time from CSV File?

Hi, I've been trying (and failing miserably) all morning to strip from a CSV file the time from it. Can somebody point me in the right direction on how to do this using sed or awk? The file looks like: "James","07/20/2009-14:40:11" "Steve","08/06/2006-02:34:37"... (5 Replies)
Discussion started by: nmuntz
5 Replies

6. Shell Programming and Scripting

awk change one value in csv based on another value in the record

I've found 2 great discussions on this forum that are tied to my question, but for some reason, neither solution works for me. I have a CSV file with many records, up to 150+ at some times. Many records have a value of H in $1. For those records, I need to add today's current date in $20. I'm... (4 Replies)
Discussion started by: mrvitas
4 Replies

7. Shell Programming and Scripting

Datestamp format 2nd change in csv file (awk or sed)

I have a csv file formatted like this: 2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances. I have got this: awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 Replies

8. Shell Programming and Scripting

Need to change date format in a csv file using awk

Example: Input csv file 00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00 00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00 Output csv file 00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies

9. Shell Programming and Scripting

Get first and last time entries for a given date in CSV file

CSV date sorted file has multiple entries for most dates. Need to eliminate all but the first and last entries of each date, being the start and end times for that day. 2009-11-20,23:57:46 2009-11-20,23:58:46 2009-11-20,23:59:46 2009-11-21,00:00:45 2009-11-21,00:01:46 2009-11-21,00:02:45... (2 Replies)
Discussion started by: mdennis6
2 Replies

10. Shell Programming and Scripting

Date format change in a csv file

Hi, We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script. Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies

LEARN ABOUT MINIX

fwtmp

fwtmp(1M)						  System Administration Commands						 fwtmp(1M)

NAME

       fwtmp, wtmpfix - manipulate connect accounting records

SYNOPSIS

       /usr/lib/acct/fwtmp [-ic]

       /usr/lib/acct/wtmpfix [file...]

DESCRIPTION

       fwtmp  reads  from  the	standard input and writes to the standard output, converting binary records of the type found in /var/adm/wtmpx to
       formatted ASCII records.  The ASCII version is useful when it is necessary to edit  bad records.

       wtmpfix examines the standard input or named files in utmpx format, corrects the time/date stamps  to  make  the  entries  consistent,  and
       writes  to the standard output.	A hyphen (-) can be used in place of file to indicate the standard input. If time/date corrections are not
       performed, acctcon(1M) will fault when it encounters certain date-change records.

       Each time the date is set, a pair of date change records are written to /var/adm/wtmpx. The first record is the old  date  denoted  by  the
       string  "old time" placed in the line field and the flag OLD_TIME placed in the type field of the utmpx structure. The second record speci-
       fies the new date and is denoted by the string new time placed in the line field and the flag NEW_TIME placed in the  type  field.  wtmpfix
       uses these records to synchronize all time stamps in the file.

       In addition to correcting time/date stamps, wtmpfix will check the validity of the name field to ensure that it consists solely of alphanu-
       meric characters or spaces. If it encounters a name that is considered invalid, it will change the login name to INVALID and write a  diag-
       nostic to the standard error. In this way, wtmpfix reduces the chance that acctcon will fail when processing connect accounting records.

OPTIONS

       -ic	Denotes that input is in ASCII form, and output is to be written in binary form.

FILES

       /var/adm/wtmpx	       history of user access and administration information

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWaccu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       acctcom(1),  ed(1),  acct(1M),  acctcms(1M),  acctcon(1M),  acctmerg(1M),  acctprc(1M),	acctsh(1M),  runacct(1M),  acct(2), acct.h(3HEAD),
       utmpx(4), attributes(5)

       System Administration Guide: Basic Administration

SunOS 5.10							    22 Feb 1999 							 fwtmp(1M)
All times are GMT -4. The time now is 04:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy