Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using commands inside sed substitution
Top Forums Shell Programming and Scripting Using commands inside sed substitution Post 302557306 by agama on Tuesday 20th of September 2011 10:09:02 PM
Old 09-20-2011
I don't think sed will work in this situation. Something like this is more along the lines of what you'll need. It assumes the date you want to transform is the first 5 tokens on each record. It can easily be adapted to convert the date from anyplace in the string, but as most log files contain the date up front, I assumed it was first.

Code:
 awk '
    function execute( cmd,  r )   # execute command, return last line of output from command. 
    {
        while( (cmd | getline) )
            r = $0;

        close( cmd );    # very important to close the pipe
        return r;
    }

    {
        $5 = $5 "~";    # assume fields 1-5 are the date
        split( $0, a, "~" );
        new_date = execute( sprintf( "date -d \"%s\" \"+%%Y%%m%%d%%H%%M%%S\"", a[1] ) );
        print new_date  a[2];
    }
' log-file-name

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String substitution on find results inside exec/xargs

What I'm trying to do is perform a copy, well a ditto actually, on the results of a find command, but some inline string substitution needs to happen. So if I run this code find ./ -name "*.tif" I get back these results. .//1234567.tif .//abcdefg.tif Now the action from exec or xargs I... (2 Replies)
Discussion started by: myndcraft
2 Replies

2. Shell Programming and Scripting

Passing UNIX commands inside sed

Hi, In sed, is it possible to match patterns by directly executing UNIX commands inside sed? For e.g. - sed "s/`cat file.txt | cut -d "|" -f2`/replace_string" Will the above command work? My expectation is to search for the second field in file.txt (file delimited by | ) and replace... (10 Replies)
Discussion started by: devanathann
10 Replies

3. Shell Programming and Scripting

How to use ftp commands inside shell script? Help please

Dears, I'm new in shell scripting and i need your help, i would like to know how can i create a script to ftp to a certain unix/linux machine/server IP address and get a file for example without user intervention? How can i force the script to use a certain username and password to access this... (4 Replies)
Discussion started by: Dendany83
4 Replies

4. Shell Programming and Scripting

ksh command substitution not executing block commands

We have a function defined in a ksh script that gets called repeatedly and concurrently by background jobs called from within the same shell script file to run PL/SQL commands against an Oracle database. The function is below: runPLSQL() { ORACLE_SID=${1} procName=${2} #... (7 Replies)
Discussion started by: rjgst5
7 Replies

5. UNIX for Dummies Questions & Answers

Variable inside command substitution

Hello people. Part of my script: SUBSETID=`echo $PMFILE |sed 's/pmresult_//' | sed 's/_*//'` MAPFILE=`find /huawei/cell /huawei/nodeb /huawei/rnc -name 'mapping_$SUBSETID.txt' |grep -v backup` Unfortunatelly variable $SUBSETID in the MAPFILE declaration will not return the... (3 Replies)
Discussion started by: drbiloukos
3 Replies

6. Shell Programming and Scripting

Using Sed to do a substitution inside ksh

I'm trying to do an ls from inside of a ksh script. I loop through the results one line at a time and attempt to do a substitution using sed to convert YYYYMMDD from the older files into the newer files. Basically sometimes the ETL load runs over midnight and half the files are off by one day... (3 Replies)
Discussion started by: Calbrenar
3 Replies

7. Shell Programming and Scripting

Automating execution of commands inside a program

I have a program dnapars I execute the program from command line as following: ./dnapars The program then prompts me some message as a user menu from where I have to select a series of options in the order R U Y R. And then I copy the output file (outfile) in another result file. I wrote the... (3 Replies)
Discussion started by: deeptisjains
3 Replies

8. Shell Programming and Scripting

Command substitution inside of a variable expression (AIX, KORN)

Hello all. This is my first post/question on this site. I’m a new Systems Analyst with previous experience with BASH. Although now I'm using AIX, and I’m trying to get a feel for the Korn shell (for those of you that don’t know AIX only uses the KORN shell). I hope I put this into the correct... (10 Replies)
Discussion started by: sydox
10 Replies

9. Shell Programming and Scripting

RMAN commands inside crontab shell script

Hello I'm trying to write simple script to delete archive logs for RMAN, unfortunately it's not working, I tried two way to do that: #!/bin/ksh echo "Start ....." rman target=/ << EOF RUN { delete force noprompt archivelog until time 'sysdate-10'; } EXIT; EOF echo "END ..." echo... (6 Replies)
Discussion started by: samer.odeh
6 Replies

10. Shell Programming and Scripting

Vi quick substitution commands

I have a script that has quite a lot of these types of entries: hello=$(who am i) good=$(blahblah) what i want to do is replace the $( and the ) with `` so that they look like this: hello=`who am i` good=`blahblah` I tried this: :%s~=$(&&)$~=`&&`$~g (3 Replies)
Discussion started by: SkySmart
3 Replies

LEARN ABOUT OPENSOLARIS

ds.log

ds.log(4)							   File Formats 							 ds.log(4)

NAME

       ds.log - Availability Suite data services log file

DESCRIPTION

       The  /var/adm/ds.log file contains the Availability Suite data services command log. The administration commands log activities to the file
       in the format:

	 date time product: message

       Note that when the size of the log file exceeds 10 Mbytes, ds.log is renamed  /var/adm/ds.log.bak  and a new /var/adm/ds.log file  is  cre-
       ated.

       The ds.log fields are:

       date

	   The	date format is mmm nn, where mmm  is  the local three-character abbreviation for the month and nn is the day of the month on which
	   the event occurred.

       time

	   The time of the event, in hh:mm:ss format.

       product

	   A product code that identifies which component of the data services produced the event. The code is separated  from	the  message  that
	   follows by a colon (:) and a space.

       message

	   A  message  that  can extend over  more  than  one  line describing the event that occurred. The second or following lines are not pre-
	   fixed by  the  date, time, and product code strings.

EXAMPLES

       The example below shows sample ds.log file content:

	 Jan 25 05:26:17 ii: iiboot suspend cluster tag <none>
	 Jan 25 05:32:02 ii: iiboot resume cluster tag <none>
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigmaster
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigshadow
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/mstvxfs
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/master01

ATTRIBUTES

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

       +---------------------+---------------------------------------------------------+
       |   ATTRIBUTE TYPE    |			   ATTRIBUTE VALUE		       |
       +---------------------+---------------------------------------------------------+
       |Architecture	     | x86						       |
       +---------------------+---------------------------------------------------------+
       |Availability	     | SUNWscmu 					       |
       +---------------------+---------------------------------------------------------+
       |Interface Stability  | Committed					       |
       +---------------------+---------------------------------------------------------+

SEE ALSO

       iiadm(1M), sndradm(1M), svadm(1M), attributes(5)

SunOS 5.11							    08 Jun 2007 							 ds.log(4)
All times are GMT -4. The time now is 12:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy