10-03-2009
Thanks for repsonding.
But it still doens't quite working. The code to get rid of the number is ..
sed 's/^\s*[0-6]\+//' myfile
but myfile still shows the numbers..
1 create view session_trace_file_name
2 as
3 select lower(d.instance_name || '_ora_' || ltrim
4 from v$process a, v$session b, v$instance d
5 where a.addr = b.paddr
6 and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d
I'd like the output should be like this
create view session_trace_file_name
as
select lower(d.instance_name || '_ora_' || ltrim
from v$process a, v$session b, v$instance d
where a.addr = b.paddr
and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
How would I get rid of lines having something else than numbers (such as tabs,white space, special characters, empty line, letters).
So I have big file with numers as follows:
12345678901
23456789012
32343678901
42345638901
52345678901
and I sometimes the file might contain some... (2 Replies)
Discussion started by: Juha
2 Replies
2. Shell Programming and Scripting
Hi all,
I have a bunch of files that are named like 12543, 467249877, etc all over some directories.These files are named only with numbers, they dont have any letters or special characters in their file names. Could you please help me out and give me some command/script to remove only those... (6 Replies)
Discussion started by: praveen_indramo
6 Replies
3. Shell Programming and Scripting
Hi all,
Can I edit this script:
find . -type f | while read i;do && mv "$i" "${i//abc/}" ;done
so that it will not only take out abc from the filename but also take out any numbers that might be in the filename as well.
An example would be,
Input:
filename abc 2009.mov
Output:... (7 Replies)
Discussion started by: Monkey Dean
7 Replies
4. Shell Programming and Scripting
Hi,
I am trying to cleanup 7 or 10 digits numeric from the file. So for example :
Input :
3M Corporation
3M Inc. 888-356-8765
3M Inc. 356-8765
3M Inc. 3568765
3M Inc. 356-8765
3M 8883568765 Inc.
Output :
3M Corporation
3M Inc. - -
3M Inc. -
3M Inc.
3M Inc. - (8 Replies)
Discussion started by: msalam65
8 Replies
5. Shell Programming and Scripting
lsps -s | awk '{print $1}'|tail -1
71680 MB
lsps -s | awk '{print $2}'|tail -1
2%
vmstat |grep lcpu |awk '{print $3}'
lcpu=8
I need to removt the MB % lcpu= from the outputs so they can show as
71680
2
8
respectively.
Please advise.
Thank you so much, (8 Replies)
Discussion started by: Daniel Gate
8 Replies
6. Shell Programming and Scripting
I have a file that has some text that looks like this
Some Text
1. More text
2. Different text
Final Text
I would like the remove the lines of text that start with the numbers.
Some Text
Final Text
I have tried to use cat file.txt | grep -Ev 1. >... (9 Replies)
Discussion started by: icculus99
9 Replies
7. Shell Programming and Scripting
Hello All,
I was wondering if someone might know how to do this. I have a word list that is format like the example below. I need to take away the :number after that... is there some kind of command I could use to remove them?
123456:5562
password:1507
123456789:989
qwerty:877... (7 Replies)
Discussion started by: 3therk1ll
7 Replies
8. Shell Programming and Scripting
how to remove all numbers from this.Using sed command
1. abcd123
2. 312jjs33 (17 Replies)
Discussion started by: rafa_fed2
17 Replies
9. Shell Programming and Scripting
Hi,
I have numerous files which have data in the following format
A|B|123.|Mr.|45.66|33|zz
L|16.|33.45|AC.|45.
I want to remove decimal point only if it is last character in a number.
O/p should be
A|B|123|Mr.|45.66|33|zz
L|16|33.45|AC.|45
I tried this
sed -e 's/.|/|/g'
Problem... (6 Replies)
Discussion started by: wahi80
6 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I am trying to remove trailing zeros from numbers in a csv file.
CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860
Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86
Can you please help.
Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies
LEARN ABOUT NETBSD
setsid
SETSID(2) BSD System Calls Manual SETSID(2)
NAME
setsid -- create session and set process group ID
LIBRARY
Standard C Library (libc, -lc)
SYNOPSIS
#include <unistd.h>
pid_t
setsid(void);
DESCRIPTION
The setsid() function creates a new session. The calling process is the session leader of the new session, is the process group leader of a
new process group and has no controlling terminal. The calling process is the only process in either the session or the process group.
Upon successful completion, the setsid() function returns the value of the process group ID of the new process group, which is the same as
the process ID of the calling process.
ERRORS
If an error occurs, setsid() returns -1 and the global variable errno is set to indicate the error, as follows:
[EPERM] The calling process is already a process group leader, or the process group ID of a process other than the calling process
matches the process ID of the calling process.
SEE ALSO
getsid(2), setpgid(2), tcgetpgrp(3), tcsetpgrp(3)
STANDARDS
The setsid() function conforms to ISO/IEC 9945-1:1990 (``POSIX.1'').
BSD
April 4, 2011 BSD