Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Modify sed script
Top Forums Shell Programming and Scripting Modify sed script Post 302548151 by chipperuga on Wednesday 17th of August 2011 03:14:28 PM
Old 08-17-2011
Modify sed script and print to csv
I'm trying to take out strings from log files and add them to a csv.

For example, in the directory now, there are 2 log files. I get the following results:
Code:
sed -e '/custodian/b' -e '/packaged by/b' -e '/package name/b' -e '/Total Data (MB) Read/b' -e '/Begin Time/b' -e d *
     packaged by = Mike Vick
     custodian = Billy Johnson
     package name = Mike_Vick.bat
Total Data (MB) Read: 11.82
Begin Time: 6/13/2011 10:29:27 AM
     packaged by = James Smith
     custodian = Paul Wall
     package name = James_Smith_2011.bat
Total Data (MB) Read: 552.97
Begin Time: 7/18/2011 11:45:52 AM

I need the output to be:
Code:
"Vick, Mike","Johnson, Billy","Mike_Vick.bat","11.82","6/13/2011"
"Smith, James","Wall, Paul","James_Smith_2011.bat","552.97","7/18/2011"

Need to:
  • Only print after "= " or ": "
  • Change "Mike Vick" to "Vick, Mike"
  • Remove time stamp after MM/DD/YYYY
Last edited by chipperuga; 08-17-2011 at 05:08 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sed modify problem in script

I am having problems with the following "sed" command only when it is issued within a bash script. #!/bin/bash cat config.xml | sed -e 's/yes/no/g' > newconfig.xml When I enter this command from the command line it works like a charm, but when run in a script as shown it "zero's out" my... (2 Replies)
Discussion started by: darthur
2 Replies

2. Shell Programming and Scripting

modify and use awk sed program

The following awk script creates a file b.dat. awk '{print substr($0,1,27),substr($2,index($2,"_")+1)," ",substr($0,49)}' a.dat > b.dat I need this script to be modified to also sum $3 values by distinct $1 and $2 fields. Current file W2_2009275 2 8 W2_2009275 2 7 W1_2009275 1... (3 Replies)
Discussion started by: mnnarendra
3 Replies

3. UNIX for Dummies Questions & Answers

How to use sed modify specific lines

Could anybody tell me how I can use sed to modify lines following specific lines? the file is as following: "TEST/SI1573.lab" 3670 8920 h# 8920 9530 hh 9530 10694 ih . "TEST/DR1/FAKS0/SI2203.lab" 9730 9580 h# 9580 9840 dh 9840 10652 ix 10652 11997 r ........ I want to modify the... (5 Replies)
Discussion started by: Jenny.palmy
5 Replies

4. Shell Programming and Scripting

sed: How to modify files in a complex way

Hello, I am new to sed and hope that someone can help me with the following task. I need to modify a txt file which has format like this: xy=CreateDB|head.queue|head.source|head.definition|rtf.edit|rtf.task|rft.cut abc|source|divine|line4|5|true into something like: head.queue=abc... (19 Replies)
Discussion started by: pinkypunky
19 Replies

5. Shell Programming and Scripting

Sed or Awk for modify hour in a crontab AIX

Hi, I want to modifiy the hour in the crontab AIX 5.3 for this line: Input: 00 22 * * * /outillage/script_exploit/bin/SavOffline.ksh > /dev/null 2>&1 Output: 30 20 * * * /outillage/script_exploit/bin/SavOffline.ksh > /dev/null 2>&1 With the awk or sed function through a ssh -q... (1 Reply)
Discussion started by: khalidou13
1 Replies

6. Shell Programming and Scripting

How to use sed to modify a line above or below matching pattern?

I couldn't figure out how to use sed or any other shell to do the following. Can anyone help? Thanks. If seeing a string (e.g., TODAY) in the line, replace a string in the line above (e.g, replace "Raining" with "Sunny") and replace a string in the line below (e.g., replace "Reading" with... (7 Replies)
Discussion started by: sprinner
7 Replies

7. Shell Programming and Scripting

Modify the file with awk,sed or perl

Hi All, I need help from any of you.Would be so thankful for your help. I/P DDDD,1045,161,1557,429,1694,800,1911,1113,2460,1457,2917> 1609,3113,1869,3317,2732,3701,3727,4132,5857,5107> 9004,6496 DDDD,1125,157,1558,429,1694,800,1911,1117,2432,1444,2906>... (2 Replies)
Discussion started by: Indra2011
2 Replies

8. Shell Programming and Scripting

Modify text file using sed

Hello all, I have some text files I need to do the following on: Delete banner page (lines 1-56) --I am doing this using sed Remove ^M --I am doing this using vi Remove trailer page --this can vary based on the contents of the file, it usually starts with *************************** I am... (5 Replies)
Discussion started by: jeffs42885
5 Replies

9. Shell Programming and Scripting

Modify xml using sed or awk

Hi All, I want to modify(changing the status from "on" to "off" status of Stage-element value from the below xml file using sed or awk: File Name: global.xml <?xml version="1.0" encoding="UTF-8"?> <config> <widget> <name>HTTP-POOL</name> <attributes> ... (5 Replies)
Discussion started by: wamqemail2
5 Replies

10. Shell Programming and Scripting

Using awk and sed to modify a create sql script

Hi, I have a file which contains the following data claim_src|clm_id,typ_id pat_src|pat_id prov_src|prov_id,clm_id,prov_name The first field is table name and second field is primary keys of the table Now I have three files which contain ddl of each table. clam_src.sql... (4 Replies)
Discussion started by: wahi80
4 Replies

LEARN ABOUT HPUX

dd-list

DD-LIST(1)						      General Commands Manual							DD-LIST(1)

NAME

       dd-list - nicely list .deb packages and their maintainers

SYNOPSIS

       dd-list [-hiusV] [--help] [--stdin] [--sources Sources_file] [--dctrl] [--version] [--uploaders] [package ...]

DESCRIPTION

       dd-list produces nicely formatted lists of Debian (.deb) packages and their maintainers.

       Input is a list of source or binary package names on the command line (or the standard input if --stdin is given).  Output is a list of the
       following format, where package names are source packages by default:

	      J. Random Developer <jrandom@debian.org>
		     j-random-package
		     j-random-other

	      Diana Hacker <diana@example.org>
		     fun-package
		     more-fun-package

       This is useful when you want, for example, to produce a list of packages that need to attention from their maintainers, e.g., to be rebuilt
       when a library version transition happens.

OPTIONS

       -h, --help
	      Print brief help message.

       -i, --stdin
	      Read package names from the standard input, instead of taking them from the command line. Package names are whitespace delimited.

       -d, --dctrl
	      Read  package  list  from standard input in the format of a Debian package control file. This includes the status file, or output of
	      apt-cache. This is the fastest way to use dd-list, as it uses the maintainer information from the input instead of  looking  up  the
	      maintainer of each listed package.

	      If no Source: line is given, the Package: name is used for output, which might be a binary package name.

       -s, --sources Sources_file
	      Read package information from the specified Sources_files.  This can be given multiple times.

	      If no Sources_files are specified, any files matching /var/lib/apt/lists/*_source_Sources will be used.

       -u, --uploaders
	      Also  list  developers  who  are named as uploaders of packages, not only the maintainers; this is the default behaviour, use --nou-
	      ploaders to prevent it. Uploaders are indicated with "(U)" appended to the package name.

       -nou, --nouploaders
	      Only list package Maintainers, do not list Uploaders.

       -b, --print-binary
	      Use binary package names in the output instead of source package names (has no effect with --dctrl if  the  Package:  line  contains
	      source package names).

       -V, --version
	      Print the version.

AUTHOR

       Lars Wirzenius <liw@iki.fi>

       Joey Hess <joeyh@debian.org>

Debian								    2011-10-27								DD-LIST(1)
All times are GMT -4. The time now is 04:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy