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 DEBIAN

ldapscripts

ldapscripts(5)							File Formats Manual						    ldapscripts(5)

NAME

       ldapscripts - Scripts to manage POSIX accounts in your LDAP directory.

DESCRIPTION

       The  ldapscripts are a set of shell (sh) scripts designed to manage POSIX accounts in an OpenLDAP directory. They can be used as standalone
       tools or within Samba 3.x's smb.conf file.

REQUIREMENTS

       The main requirements are the OpenLDAP client tools (ldapadd, ldapsearch, ldapdelete, ...). Other commands are called in  the  scripts  but
       should come with your OS (sed, grep, cut, ...).

CONFIGURATION

       The  main  configuration  of  the  ldapscripts  is  usually the file /etc/ldapscripts/ldapscripts.conf (or /usr/local/etc/ldapscripts/ldap-
       scripts.conf, depending on your system). Modify it to fit your needs before using the scripts. Each script also uses a "runtime" file, usu-
       ally /usr/lib/ldapscripts/runtime (or /usr/local/lib/ldapscripts/runtime). You don't need to modify this file.

TEMPLATES

       Each  script  that  adds  information to the directory uses a template. Templates are directly embedded at the end of the scripts but it is
       also possible to use external template files (see GTEMPLATE, UTEMPLATE and MTEMPLATE variables in the configuration  file).  Each  template
       consists  of  a	preformatted  LDIF file using special keywords that will be replaced on-the-fly. Sample files are provided for your conve-
       nience : ldapaddgroup.template.sample, ldapadduser.template.sample and ldapaddmachine.template.sample. It is strongly advised to use  those
       files instead of modifying the embedded (default) templates in the scripts.

       Sample templates include every keyword you can use. One special additional keyword is the <ask> keyword that will trigger user input to get
       the attribute value interactively.

USING AS STANDALONE TOOLS

       Each script can be used as a standard command-line tool. Check their man pages to get help.

USING WITH SAMBA 3.x
       Each Samba 3.x smb.conf "xxx script" option has a matching script. Modify you smb.conf file this way to call them :

       # [...]
       add machine script = /usr/local/sbin/ldapaddmachine '%u' sambamachines
       add user script = /usr/local/sbin/ldapadduser '%u' sambausers
       add group script = /usr/local/sbin/ldapaddgroup '%g'
       add user to group script = /usr/local/sbin/ldapaddusertogroup '%u' '%g'
       delete user script = /usr/local/sbin/ldapdeleteuser '%u'
       delete group script = /usr/local/sbin/ldapdeletegroup '%g'
       delete user from group script = /usr/local/sbin/ldapdeleteuserfromgroup '%u' '%g'
       set primary group script = /usr/local/sbin/ldapsetprimarygroup '%u' '%g'
       rename user script = /usr/local/sbin/ldaprenameuser '%uold' '%unew'
       # [...]

SEE ALSO

       ldapdeletemachine(1), ldapmodifymachine(1), ldaprenamemachine(1),  ldapadduser(1),  ldapdeleteuserfromgroup(1),	ldapfinger(1),	ldapid(1),
       ldapmodifyuser(1), lsldap(1), ldapaddusertogroup(1), ldaprenameuser(1), ldapinit(1), ldapsetpasswd(1), ldapaddgroup(1), ldapdeletegroup(1),
       ldapsetprimarygroup(1), ldapmodifygroup(1), ldaprenamegroup(1), ldapaddmachine(1), ldapdeleteuser(1).

AVAILABILITY

       The ldapscripts are provided under the GNU General Public License v2 (see COPYING for more details).  The latest version of the ldapscripts
       is available on : http://contribs.martymac.org

BUGS

       Sometimes,  that kind of message may appear in the log file : Additional information: value does not conform to assertion syntax .  Setting
       slapd's debug level to 32 shows additional details : get_ava: illegal value for attributeType uidNumber .  This is *not* a bug : the  ldap-
       scripts	tend to use the power of LDAP filters to easily find users (or groups) using either a uidNumber (numerical value) or a uid (string
       value). The following filter (used by ldapfinger(1)) will generate the above message if $_USER  is  a  login  :	"(|(&(objectClass=posixAc-
       count)(|(uid=$_USER)(uidNumber=$_USER)))   (&(objectClass=posixGroup)(|(cn=$_USER)(gidNumber=$_USER))))"   because  filter  part  "(uidNum-
       ber=$_USER)" requires an integer but gets a string. You can mostly ignore those warnings.

								  January 1, 2006						    ldapscripts(5)
All times are GMT -4. The time now is 01:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy