Replace a pattern in a file with a generated number using sed or awk
my file has thousands of line but let me show what i want to achieve... here is one line from that file
here you can observe that for
there is a comma inbetween single quotes... here instead of this comma i want to replace a varchar say Xox9870563xoX
we cant directly cut using this single quotes since there are others strings having single quotes... one way we could do is if there is any comma between ,' and ', then replace with that number.... is this achievable using sed or awk...?
hi guys,
I want to do pattern matching with awk or sed but I don't know how. here's what I want:
I have a line number for a pattern that I have already found using grep, and I know a pattern like "---" that happens a few lines above that certain line number. I want to print out the chunk... (1 Reply)
Hello friends,
I have a C source code containing sql statements. I use the following sed command to print all the sql blocks in the source code....
sed -n "/exec sql/,/;/p" Sample.cpp
The above sed command will print the sql blocks based on the pattern "exec sql" & ";"... (2 Replies)
Hi,
I have a situation where I want to replace some occurrences of ".jsp" into ".html" inside a text file.
For Example:
If a pattern found like <a href="http://www.mysite.com/mypage.jsp"> it should be retained.
But if a pattern found like <a href="../mypage.jsp"> it should be changed to... (4 Replies)
My goal is to make a script to find/replace the variable "PORT" with a unique number.
Like the following
<VirtualHost 174.120.36.236:PORT>
ServerName architect.com.ph
ServerAlias www.architect.com.ph
DocumentRoot /home/architec/public_html
ServerAdmin... (16 Replies)
Hi ,
My file have data like
4:ALMOST NEVER PR 1925836
5:NEVER PR W DDA 5857610
6:NEVER PR WO DDA 26770205
but i want to replace the spaces before last numric digits out put should be like this
4:ALMOST NEVER PR=1925836
5:NEVER PR W DDA=5857610
6:NEVER PR WO... (7 Replies)
Hi
I have written a shell script which used sed code below
sed -i 's/'"$Pattern"'/ /g' $FileName
I want to count the length of Pattern and replace it with equal number of spaces in the FileName.
I have used $(#pattern) to get the length but could not understand how to replace... (8 Replies)
Hi
I know sed and awk has options to give range of line numbers, but
I need to replace pattern in specific lines
Something like
sed -e '1s,14s,26s/pattern/new pattern/' file name
Can somebody help me in this....
I am fine with see/awk/perl
Thank you in advance (9 Replies)
I have a sample text format as given below
<Text Text_ID="10155645315851111_10155645333076543" From="460350337461111" Created="2011-03-16T17:05:37+0000" use_count="123">This is the first text</Text>
<Text Text_ID="10155645315851111_10155645317023456" From="1626711840902323"... (3 Replies)
Discussion started by: my_Perl
3 Replies
LEARN ABOUT DEBIAN
mysqmail-courier-logger
mysqmail-logger(8) System Manager's Manual mysqmail-logger(8)NAME
mysqmail-courier-logger - logs courier-imap traffic to a mysql database
SYNOPSIS
mysqmail-courier-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-courier-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq-
mail-courier-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf.
mysqmail-courier-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS pop_access (
id varchar(32) NOT NULL default '',
uid int(11) NOT NULL default '65534',
gid int(11) NOT NULL default '65534',
home varchar(255) NOT NULL default '',
shell varchar(255) NOT NULL default '',
mbox_host varchar(120) NOT NULL default '',
crypt varchar(50) NOT NULL default '',
passwd varchar(50) NOT NULL default '',
active int(11) NOT NULL default '1',
start_date date NOT NULL default '0000-00-00',
expire_date date NOT NULL default '0000-00-00',
quota_size int(11) NOT NULL default '0',
type varchar(20) NOT NULL default 'default',
memo text,du bigint(20) NOT NULL default '0',
another_perso varchar(5) NOT NULL default 'no',
redirect1 varchar(255) default NULL,
redirect2 varchar(255) default NULL,
localdeliver varchar(10) NOT NULL default 'yes',
pop3_login_count int(9) NOT NULL default '0',
pop3_transfered_bytes int(14) NOT NULL default '0',
imap_login_count int(9) NOT NULL default '0',
imap_transfered_bytes int(14) NOT NULL default '0',
last_login int(14) NOT NULL default '0',
PRIMARY KEY (id,mbox_host) ) TYPE=MyISAM
To have mysqmail-courier-logger working, you should have issued mkfifo /var/log/courier.fifo to create the fifo and use nohup cat
/var/log/courier.fifo | /usr/bin/mysqmail-courier-logger > /dev/null 2>&1 & to launch it.
VERSION
This documentation describes mysqmail-courier-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.
SEE ALSO qmail-send(3), syslog(3), logger(8)mysqmail-logger(8)