Sponsored Content
Full Discussion: remove the numbers
Top Forums Shell Programming and Scripting remove the numbers Post 302358549 by Beginer0705 on Saturday 3rd of October 2009 05:48:41 AM
Old 10-03-2009
Question

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

How to remove all lines with something other than numbers

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

how to remove files with only numbers as file names?

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

How to remove numbers from filename

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

Remove Multiple numbers from file.

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

awk & remove other than numbers

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

Remove Numbers from file

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

Bash, remove numbers after colon

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

Remove numbers

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

Remove '.' from file for numbers ending in '.'

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

Remove trailing zeros from numbers

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
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
All times are GMT -4. The time now is 10:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy