08-18-2011
csv file field needs to be changed current system date with awk
HI,
I have csv file with records as shown below.
HTML Code:
4102,Bangalore,G10,21,08/17/2011 09:28:33:188,99,08/17/2011 09:27:33:881,08/17/2011 09:27:39:22,1580807561,404450302456086,919740330452,3553100467504101,2,NULL,NULL,Ericsson-South_Central,122.170.0.129,airtelgprs.com,404,45,16274,255,443,223.177.40.84,74.125.236.81,443,881,67,3522,2210,11,12,1,1,870,2284,5141,0,443,1,5,1580807561,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,27043,NULL,
here fifth $5 field is some date and time say 08/17/2011 09:28:33:188
i want to change that field with current system date and time for all the records.ate time is
say current system date 08/18/2011 15:14:57:188
any thought with awk ?
Thanks,
Raghavendra
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I want to check what day is today (like mon,Tue,wed)
When i checked the syntax, i dont see there is a format specifier for getting the day. Let me know how to get the same.
I am very new to unix and so I am asking some basic questions.
cheers,
gops (2 Replies)
Discussion started by: gopskrish
2 Replies
2. UNIX for Dummies Questions & Answers
How do I create a shell script that would get the current system date in format of yyyymmdd and use that result to concatenate it to a filename that it would look like this: sample20051024.dat
example
--------
current system date: 24-Oct-2005
filename: sample.dat
when the shell script... (5 Replies)
Discussion started by: wtolentino
5 Replies
3. Shell Programming and Scripting
Hi,
Anybody knows how to get what date was 28 days ago of the current system date through UNIX script.
Ex : - If today is 28th Mar 2010 then I have to delete the files which arrived on 1st Mar 2010, (15 Replies)
Discussion started by: kandi.reddy
15 Replies
4. UNIX for Dummies Questions & Answers
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
5. UNIX for Dummies Questions & Answers
Hi Guys,
Anyone who knows how to compare the current date with the a file containing a date, say for example I have a file that looks like this:
Command was launched from partition 0.
------------------------------------------------
Executing command in server server6
Fri Dec 16... (7 Replies)
Discussion started by: rymnd_12345
7 Replies
6. UNIX and Linux Applications
Hi Everyone,
New to the forum, and have my first question.
I have the following Macro currently being used within Telnet to run a report for the date being entered. However, now I need the Macro to input the day after today to the the day after today.
Example: If today is May 9, 2012 - the... (0 Replies)
Discussion started by: CipherEffect
0 Replies
7. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
8. Shell Programming and Scripting
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
Hi,
In a csv file, I want to select records where first column has zero or multiple spaces.
Eg: abc.csv
,123,a
,22,b
,11,c
a,11,d
So output should be:
,123,a
,22,b
,11,c
Please advise (5 Replies)
Discussion started by: vegasluxor
5 Replies
10. Shell Programming and Scripting
Hello, so basically i have a txt file containing "foto's" named YYYY-MM-DD_HH.mm.ss.jpeg.
But since it can probably not convert it it changes the date to the current date. What am i doing wrong?
#!/bin/bash
inputDateFmt()
{
sed -e 's/_/ /g' -e 's/\./:/g' <<< "$1"
}
begindatum=$(date... (3 Replies)
Discussion started by: Rovester
3 Replies
LEARN ABOUT DEBIAN
interface-order
INTERFACE-ORDER(5) resolvconf INTERFACE-ORDER(5)
NAME
interface-order - resolvconf configuration file
DESCRIPTION
The file /etc/resolvconf/interface-order is used to control the order in which resolvconf nameserver information records are processed by
those resolvconf update scripts that consult this file. (The name of the file is apt because a resolvconf nameserver information record is
named after the interface with which it is associated.)
The file contains a sequence of shell glob patterns, one per line. The position of a record in the order is the point at which its name
first matches a pattern.
Patterns may not contain whitespace, slashes or initial dots or tildes. Blank lines and lines beginning with a '#' are ignored.
Resolvconf update scripts in /etc/resolvconf/update.d/ that consult this file include the current default versions of dnsmasq, pdnsd and
libc. (Actually they don't read the file directly; they call the utility program /lib/resolvconf/list-records which lists records in the
specified order and omits the names of empty records.)
EXAMPLE
# /etc/resolvconf/interface-order
# Use nameservers on the loopback interface first.
lo*
# Next use records for Ethernet interfaces
eth*
# Next use records for Wi-Fi interfaces
wlan*
# Next use records for PPP interfaces
ppp*
# Last use other interfaces
*
AUTHOR
Resolvconf was written by Thomas Hood <jdthood@gmail.com>.
COPYRIGHT
Copyright (C) 2004, 2011 Thomas Hood
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
resolvconf(8)
resolvconf 18 May 2011 INTERFACE-ORDER(5)