05-21-2013
Thanks
Cheers, That certainly does the job.
Would love to know how to do it in sed if anyone else fancies a crack at it...
Thanks again, that will get me out of the hole.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello. I am trying to convert occurrences of 'NULL' from a datafile. The 'NULL' occurences appears at this:
|NULL| NULL|NULL| NULL|NULL| NULL|NULL| NULL|
There should be 52 fields per line.
I would like any occurrence of | NULL| or |NULL| to appear as '||'
Currently I am using this sed... (2 Replies)
Discussion started by: bestbuyernc
2 Replies
2. UNIX for Dummies Questions & Answers
Hi Gurus,
I have a small requirement.
Let suppose i have a file test.txt
test.txt contains
Dispatched date = '2008-04-08'
Name = 'Logers'
Now i want to add one more line to it as Number of Responses = "$a"
$a will be chnaging dynamically which i had grepped it in the script.
Now i... (6 Replies)
Discussion started by: pssandeep
6 Replies
3. Shell Programming and Scripting
Hi All,
I am facing a small problem in sed. I want to insert a line in the existing file.
Existing code:
access to attr=userPassword
by self write
by * auth
access to *
by self write
by users read
by anonymous auth
Desired code:
access to attr=userPassword
by self... (14 Replies)
Discussion started by: nua7
14 Replies
4. Shell Programming and Scripting
Hi All,
I need to pick up data on both sides of "=" sign.
For eg, following is the context that I have.
125.156.125.147=machine1
147.125.185.156=machine2
147.125.185.159=machine3
Can I have the ip address in one variable and machine name in another variable using sed or awk.
... (1 Reply)
Discussion started by: nua7
1 Replies
5. Shell Programming and Scripting
Hi
I have a file, with format like:
column1|coulumn2|column3|column4
A|X|K|18
L|O|R|31,42,25
G|H|I|55,66
L|E|Q|25,31,94
output required:
column1|coulumn2|column3|column4
A|X|K|18
L|O|R|31,25
L|E|Q|25,31
Input File Format: All columns are seperated using |, last column... (8 Replies)
Discussion started by: New to awk
8 Replies
6. Shell Programming and Scripting
Hello everyone,
unfortunately I am no unix nor scripting guru, which is why I am asking for help here. I am trying to reformat a .csv file using sed or awk which has the following format:
a,b,C-D-E,f,g
h,i,J,k,l
m,n,O-P-Q-R-S,t,u
v,w,X-Y,z,a
It's basically a 5-field text file which has an... (7 Replies)
Discussion started by: awayand
7 Replies
7. Shell Programming and Scripting
This post is in reference to https://www.unix.com/shell-programming-scripting/137977-tricky-sed-awk-question-post302428154.html#post302428154
I am trying to go the opposite direction now:
I have the following file:
a,b,C,f,g
a,b,D,f,g
a,b,E,f,g
h,i,J,k,l
m,n,O,t,u
m,n,P,t,u
m,n,Q,t,u... (3 Replies)
Discussion started by: awayand
3 Replies
8. Shell Programming and Scripting
Hi,
I have a file which contains two strings: AAAAA and BBBBB
I have two variables in my script:
DATE="03/21/2010"
aDate="20100321"
I need to replace string AAAAA with variable $DATE and BBBBB with $aDate. Here is what I do
sed "s/AAAAA/$DATE/" $BASIC_TMPLT | sed "s/BBBBB/$aDate/" >... (4 Replies)
Discussion started by: axed
4 Replies
9. Shell Programming and Scripting
Hi All,
I have one file with below type of data in it,
$ cat test.txt
###123
###xyxytuerwb
###2
###tyupe
Here I would like to replace all the characters with "x" after the 3 "###" with the same number of characters.
Can you please help me to achieve this. (7 Replies)
Discussion started by: gr8_usk
7 Replies
10. UNIX for Dummies Questions & Answers
Hi
Can some one tell what does this sed command do
sed 's/*$//g
I am more curious on the highlighted part , can some one explain what does that mean.
Thanks
Sri (1 Reply)
Discussion started by: Sri3001
1 Replies
proto(4) Kernel Interfaces Manual proto(4)
NAME
proto - prototype job file for at
SYNOPSIS
DESCRIPTION
When a job is submitted to or the job is constructed as a POSIX shell script (see at(1)). The job file is created in as follows:
o creates a header describing the job as an job or a job. jobs submitted to all queues other than queue are listed as jobs. The header
is:
for an job, or
for a job.
o A set of POSIX shell commands is added to make the environment (see environ(5)) for the job the same as the current environment.
o then copies text from the prototype file to the job file, except for special variables that are replaced by other text:
Replaced by the current working directory.
Replaced by the current file size limit (see
ulimit(2)).
Replaced by the current umask (see
umask(2)).
Replaced by the time at which the job should be run,
expressed as seconds since January 1, 1970, 00:00 Coordinated Universal Time, preceded by a colon.
Replaced by text read by
from the standard input (that is, the commands provided to to be run in the job).
o When a job is submitted to queue queue, uses the file as the prototype file if it exists. Otherwise, it uses the file
EXAMPLES
The following file creates commands to change the current directory, file size limit, and umask in the job to their respective values as
they existed when was originally run. These commands are inserted before the commands in the job:
SEE ALSO
at(1), queuedefs(4).
STANDARDS CONFORMANCE
proto(4)