Login or Register to Ask a Question and Join Our Community

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

LEARN ABOUT DEBIAN

hotswaprc

HOTSWAPRC(5)							File Formats Manual						      HOTSWAPRC(5)

NAME

       hotswaprc - configuration file for  hotswap

DESCRIPTION

       /etc/hotswaprc is the global configuration file for the hotswap utility.

       It  allows system administrators to specify arbitrary shell scripts to be run after a device is inserted, as well as before and after it is
       removed. Scripts are selected according to the model name retrieved from the device. This is particularly helpful for automatic	configura-
       tion of CD-RW drives, which require SCSI emulation and bypass normal access via the IDE subsystem.

       hotswaprc  is  implemented  as  an  Extensible Mark-up Language (XML) application.  XML documents are structured using elements of the form
       <tag-name> content <tag-name>. A Document Type Definition (DTD) describes the possible content of each element.

       Please refer to the XML specification for more information. The hotswap distribution also contains an example file,  doc/hotswaprc.example,
       which includes the DTD for the configuration file format.

ELEMENTS

       <hotswap>
	      This is the root element of the document. Each valid hotswaprc must contain exactly one <hotswap> element. The <hotswap> element may
	      contain an arbitrary number of <device> elements.

       <device>
	      The configuration file contains one <device> element for every device for which scripts are defined. The <device>  element  is  com-
	      posed of the following elements in this order: <name>, <post-insert>, <pre-remove>, <post-remove>. All but <name> are optional.

       <name> The content of this element is the model identification string of the IDE device the current <device> element refers to.

       <post-insert>
	      Contains the shell script that is to be executed after the device has been inserted and registered with the kernel.

       <pre-remove>
	      Contains the shell script that is to be run before hotswap attempts to unregister the device.

       <post-remove>
	      Contains the shell script that is to be run after the device had been unregistered.

REPORT BUGS

       Report bugs to t.stadelmann1@physics.ox.ac.uk.

AUTHOR

       Written by Tim Stadelmann.

SEE ALSO

       hotswap(1), xhotswap(1).

COPYRIGHT

       Copyright (c) 2002-2003 Tim Stadelmann.

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License (GPL), Version 2 or
       any later version published by the Free Software Foundation.

								26th November 2002						      HOTSWAPRC(5)
All times are GMT -4. The time now is 06:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy