Extract number from string.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract number from string.
# 8  
Old 02-28-2017
Code:
typeset -i num=$(echo 'Insert completed. No rows added ' | awk '{print $(NF-2)}')

# 9  
Old 03-01-2017
Using the form ... | tr -dc '[:digit:]' works fine for me. The definition for the -c flag is for the complement, i.e. the opposite so it should delete everything except digits.

Can you check your manual page to see if the ic flag is supported?

If you are in bash and the message is always the same format, you could also do this:-
Code:
read a b rows c < <(echo "Insert completed. 100 rows added.")
echo $rows

It only calls echo so avoids the extra process for tr, awk or whatever and doesn't care if you have digits or the text No

You can replace the echo command with whatever command you need to generate the output in the first place.


Does this help?

Robin

Last edited by rbatte1; 03-01-2017 at 06:52 AM.. Reason: Extra comment
# 10  
Old 03-01-2017
Sed alternative:

Code:
echo "Insert completed. 100 rows added" | sed 's/\([^[0-9]*\)\([0-9]*\)\(.*\)/\2/'

# 11  
Old 03-01-2017
Hi.

Also:
Code:
echo "Insert completed. 100 rows added"|sed 's/[^0-9]//g'

producing:
Code:
100

On a system:
Code:
OS, ker|rel, machine: Linux, 3.16.0-4-amd64, x86_64
Distribution        : Debian 8.7 (jessie) 
sed (GNU sed) 4.2.2

Best wishes ... cheers, drl
# 12  
Old 03-03-2017
Try
Code:
print "Insert completed. 100 rows added" | sed 's/[^0-9]//g'

# 13  
Old 03-04-2017
bash / ksh93 / zsh:

Code:
str='Insert completed. 100 rows added'
echo "${str//[!0-9]}"


Last edited by Scrutinizer; 03-04-2017 at 03:55 AM.. Reason: Corrected ash -> bash. Thanks Don...
# 14  
Old 03-04-2017
Quote:
Originally Posted by Scrutinizer
ash / ksh93 / zsh:

Code:
str='Insert completed. 100 rows added'
echo "${str//[!0-9]}"

This also works with recent versions of bash (at least GNU bash, version 3.2.57 and later; but I don't know how far back it appeared in earlier releases).

This form of variable substitutions is an extension that is allowed, but neither required nor explicitly mentioned, by the POSIX standards.
This User Gave Thanks to Don Cragun For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract every repeated string between two specific string?

Hello guys, I have problem with hpux shell script. I have one big text file that contains like SOH bla bla bla bla bla bla ETX SOH bla bla bla ETX SOH bla bla bla ETX What I need to do is save first SOH*BLA into file1.txt, save second SOH*BLA into file2.txt and so on.... (17 Replies)
Discussion started by: sembii
17 Replies

2. Shell Programming and Scripting

Search String and extract few lines under the searched string

Need Assistance in shell programming... I have a huge file which has multiple stations and i wanted to search particular station and extract few lines from it and the rest is not needed Bold letters are the stations . The whole file has multiple stations . Below example i wanted to search... (4 Replies)
Discussion started by: ajayram_arya
4 Replies

3. Shell Programming and Scripting

Extract number part from the string in ksh 88

I have to extract number part (Date and timestamp part ) from the following 3 strings AB_XYZA_20130930183017.log AB_DY_XYZA_20130930183017.log AB_GZU_20130930183017.log Output should be 20130930183017 Please help me to get the string like above Thanks (2 Replies)
Discussion started by: smile689
2 Replies

4. Shell Programming and Scripting

how to extract last word and a number from a string

I have the following script (which I made by my self) #!/bin/bash # add a few empty lines to make it more legible # add a date description on each update interval echo "" >> /home/user/DYN_DNS_IP_change.log echo "" >> /home/user/DYN_DNS_IP_change.log echo "" >>... (6 Replies)
Discussion started by: mahirzukic2
6 Replies

5. Shell Programming and Scripting

to extract string from main string and string comparison

continuing from my previous post, whose link is given below as a reference https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569 consider there is create table commands in a file for eg: CREATE TABLE `Blahblahblah` ( `id` int(11) NOT NULL... (2 Replies)
Discussion started by: vivek d r
2 Replies

6. Shell Programming and Scripting

Extract string from multiple file based on line count number

Hi, I search all forum, but I can not find solutions of my problem :( I have multiple files (5000 files), inside there is this data : FILE 1: 1195.921 -898.995 0.750312E-02-0.497526E-02 0.195382E-05 0.609417E-05 -2021.287 1305.479-0.819754E-02 0.107572E-01 0.313018E-05 0.885066E-05 ... (15 Replies)
Discussion started by: guns
15 Replies

7. Shell Programming and Scripting

Extract number that comes after a given string

Hi! I have a file that contains non-regular strings like: SCSGTI:N="$4,0,1,4,34622991111-->RemoteSPC: 1111", NWID=1; SCSGTI:N="$4,0,1,4,34622991211-->RemoteSPC: 1211", NWID=1; SCSGTI:N="$4,0,1,4,*-->RemoteSPC: 2112,Sec:RemoteSPC: 2212", NWID=1; SCSGTI:N="$4,10,1,4,34622999213-->RemoteSPC:... (4 Replies)
Discussion started by: Flavius
4 Replies

8. Shell Programming and Scripting

changing number in bash (number is in form of string)

I have a txt file as database. when i run my program what it does is it ask me for 3 name and stored in the file as name1:name2:name3:1 when u enter 3 name it add those in file as above format and add 1 at the end. I what i want is if i enter same names again it changes that 1 to 2 and so... (3 Replies)
Discussion started by: Learnerabc
3 Replies

9. Shell Programming and Scripting

Search for string in a file and extract another string to a variable

Hi, guys. I have one question: I need to search for a string in a file, and then extract another string from the file and assign it to a variable. For example: the contents of the file (group) is below: ... ftp:x:23: mail:x:34 ... testing:x:2001 sales:x:2002 development:x:2003 ...... (6 Replies)
Discussion started by: daikeyang
6 Replies

10. Shell Programming and Scripting

How to extract variable number from a String

hi,I am new to shell script,I have String,like this: Number of rows exported: 5321 the numbe at end could changing,how can I extract this number and assign it to a variable,then use it later in script. thanks. (19 Replies)
Discussion started by: vitesse
19 Replies
Login or Register to Ask a Question