07-07-2010
Search and remove digits (if exist) from end of the string
Hi Experts,
Here is what I am trying to do.
1) say I have a file with below strings
database1
database2
database3
data10gdb1
data10gdb2
databasewithoutdigit
2) I want to get the below output.
(- if there is any digit at the end of the string, I need to remove it)
(- Any digit which is not at the end of the string shoud remain unchanged)
database
database
database
data10g
data10g
databasewithoutdigit
Thanks
Shelly
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a string like xxxxxx44. What's the best way to extract the digits (one or more) in a ksh script?
Thanks (6 Replies)
Discussion started by: offirc
6 Replies
2. Shell Programming and Scripting
Hey guys, Can sed or another command be used to examine a path such as
/home/test/blah/blahand check to see if the last character is a "/" and if so remove it
So this is what should happen:
/home/test/blah/blahnothing happens, this is ok
/home/test/blah/blah/the "/" at the end is... (6 Replies)
Discussion started by: tret
6 Replies
3. Shell Programming and Scripting
Hi All,
How to remove a box like special character which appears at the end of a string/line/record. I have no clue what this box like special character is. It is transparent square like box. This appears in a .DAT file at the end of header.
I'm to compare a value in header with a parameter.... (16 Replies)
Discussion started by: Qwerty123
16 Replies
4. Shell Programming and Scripting
Hi
i had String like
UID: ABC345QWE678GFK345SA90, LENGTH 32
when I used awk ' FS, {print $1}' prints
ABC345QWE678GFK345SA90,
how can i getrid of that coma at the end of the string.
Thanks in advance.. (14 Replies)
Discussion started by: Reddy482
14 Replies
5. Shell Programming and Scripting
Hi there, im sure this is really simple but i have some strings like this
e1000g123001
e1000g0
nge11101
nge3and i want to create two variables ($DRIVER and $INSTANCE). the first one containing the alpha characters that make up the first part of the string, e.g. e1000g or nge and the... (9 Replies)
Discussion started by: rethink
9 Replies
6. Shell Programming and Scripting
I would like to search between two a string. I thought this would be easy. The is always at the beginning of a line.
The code:
gawk '/^/{d=$1},/searchstring/,/^(d+1)/'
or
gawk '/^/,/searchstring/,/^/'
did not return the desired result.
inputfile.txt
999 some text searchstring some... (6 Replies)
Discussion started by: sdf
6 Replies
7. Shell Programming and Scripting
I have this:
301205 0000030000041.49000000.00 2011111815505 908
301205 0000020000029.10000000.00 2011111815505 962
301205 0000010000027.56000000.00 2011111815505 3083
312291 ... (2 Replies)
Discussion started by: herot
2 Replies
8. Shell Programming and Scripting
Hi,
I am trying to remove lines once a string is found till another string is found including the start string and end string. I want to basically grab all the lines starting with color (closing bracket). PS: The line after the closing bracket for color could be anything (currently 'more').... (1 Reply)
Discussion started by: Dabheeruz
1 Replies
9. Shell Programming and Scripting
Dear All
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB... (5 Replies)
Discussion started by: suryanarayana
5 Replies
10. Shell Programming and Scripting
How can I extract digits at the end of a string in UNIX shell scripting or perl?
cat file.txt
abc_d123_4567.txt
A246_B789.txt
B123cc099.txt
a123_B234-012.txt
a13.txt
What can I do here? Many thanks.
cat file.txt | sed "s/.txt$//" | ........
4567
789
099
012
13 (11 Replies)
Discussion started by: mingch
11 Replies
LEARN ABOUT PHP
fbsql_db_status
FBSQL_DB_STATUS(3) 1 FBSQL_DB_STATUS(3)
fbsql_db_status - Get the status for a given database
SYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier])
DESCRIPTION
Gets the current status of the specified database.
PARAMETERS
o $database_name
- The database name.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants:
o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database
by using a port number. FBExec can be available on the server but no connection has been made for it.
o FBSQL_UNKNOWN - The Status is unknown.
o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database.
o FBSQL_STARTING - The database is starting.
o FBSQL_RUNNING - The database is running and can be used to perform SQL operations.
o FBSQL_STOPPING - The database is stopping.
o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.
SEE ALSO
fbsql_start_db(3), fbsql_stop_db(3).
PHP Documentation Group FBSQL_DB_STATUS(3)