Using awk and sed to modify a create sql script Post: 302922344

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. 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. 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...

4. Shell Programming and Scripting

Wrap lines with awk to create SQL script

Greetings! Some of my files list hardware errors (we test electronic components), some have none. If the file name has no errors, I still want to display a message like "No error", else I display the error from the file itself. I came up with this (with help) for myfile in `find . -name...

5. Shell Programming and Scripting

Modify sed script

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: 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 =...

6. 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>...

7. Shell Programming and Scripting

Calling Pl/sql function in shell script to modify csv

I need to 1.Open a csv 2.Process the csv i.e. Modify 2 column in the csv. To modify the column the value needs to be passed to a pl/sql function and the return value should be updated For eg: If column 2 E,then E will be passed in database function which will return Employee. 3. Write a...

8. 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> ...

9. UNIX for Beginners Questions & Answers

awk and sed script to create one output CSV file

Hi All , I would require your help to generate one output file after post processing of one CSV file as stated below This file is just a small cut from a big file . Big file is having 20000 lines PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9...

10. UNIX for Beginners Questions & Answers

Sed, awk or another bash command to modify string with the content of another file

Hello everybody, I would like modify some strings using sed or another command line with the content file. For example: - {fqdn: "server-01" , ip: "server-01"} - {fqdn: "server-02" , ip: "server-02"} - {fqdn: "server-03" , ip: "server-03"} - {fqdn: "server-04" , ip: "server-04"} My...

LEARN ABOUT DEBIAN

mysqmail-postfix-logger

mysqmail-postfix-logger(8)				      System Manager's Manual					mysqmail-postfix-logger(8)

NAME

       mysqmail-postfix-logger - logs smtp traffic to a mysql database

SYNOPSIS

       mysqmail-postfix-logger subprogram [ args ...  ]

DESCRIPTION

       mysqmail-postfix-logger	reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
       (configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to  field	of
       the smtp traffic table.

       mysqmail-postfix-logger uses a table corresponding to this one:

       CREATE TABLE  IF NOT EXISTS smtp_logs (
	 id int(11) NOT NULL auto_increment,
	 newmsg_id bigint(20) default NULL,
	 bounce_qp int(11) default NULL,
	 bytes int(11) NOT NULL default '0',
	 sender_user varchar(128) NOT NULL default '',
	 sender_domain varchar(128) NOT NULL default '',
	 delivery_id bigint(20) default NULL,
	 delivery_user varchar(128) NOT NULL default '',
	 delivery_domain varchar(128) NOT NULL default '',
	 delivery_success enum('yes','no') NOT NULL default 'no',
	 time_stamp timestamp(14) NOT NULL,
	 PRIMARY KEY  (id),
	 UNIQUE KEY bounce_qp (bounce_qp),
	 UNIQUE KEY newmsg_id (newmsg_id),
	 KEY sender_domain (sender_domain),
	 KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;

VERSION

       This documentation describes mysqmail-postfix-logger version 0.1.4.  See http://gplhost.com/softwares-mysqmail.html for updates.

SEE ALSO

       syslog(3), logger(8)

															mysqmail-postfix-logger(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sed modify problem in script

Discussion started by: darthur

2. Shell Programming and Scripting

modify and use awk sed program

Discussion started by: mnnarendra

3. Shell Programming and Scripting

Sed or Awk for modify hour in a crontab AIX

Discussion started by: khalidou13

4. Shell Programming and Scripting

Wrap lines with awk to create SQL script

Discussion started by: alan