Extract number from string.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract number from string.
# 1  
Old 02-28-2017
Extract number from string.

Hi

I am on Sun os. I have data in the below format and I need to grab the number out from the string.

Quote:
Insert completed. 100 rows added
O/p needed:

Quote:
100
---------- Post updated at 12:39 PM ---------- Previous update was at 12:32 PM ----------

I tried this but I am getting . at the front

Quote:
echo "Insert completed. 100 rows added" | tr -d '[:alpha:]'
# 2  
Old 02-28-2017
Hello dsravanam,

Could you please try following and let me know if this helps.
Code:
echo "Insert completed. 100 rows added" | awk '{gsub(/[^[0-9]]*/,"");print}'
OR
echo "Insert completed. 100 rows added" | awk '{print $(NF-2)}'
OR
echo "Insert completed. 100 rows added" | awk '{gsub(/[[:alpha:]]|[[:punct:]]| +/,"");print}'

Thanks,
R. Singh
# 3  
Old 02-28-2017
Code:
echo 'Insert completed. 100 rows added ' | awk '{print $(NF-2)}'

# 4  
Old 02-28-2017
So - punctuation chars and space remain? Where did you get the [:alpha:] character class?
# 5  
Old 02-28-2017
works fine with integer :
Code:
$ echo "Insert completed. 100 rows added" | tr -dc '[:digit:]'
100

This User Gave Thanks to Akshay Hegde For This Post:
# 6  
Old 02-28-2017
I think none of them are working fine.

Code:
echo "Insert completed. 100 rows added" | tr -dc '[:digit:]'

gives

Code:
Insert completed. rows added

The other one below is not working as it is bringing characters when the string is like below

Code:
echo 'Insert completed. No rows added ' | awk '{print $(NF-2)}'


Code:
No


Last edited by rbatte1; 03-01-2017 at 06:44 AM.. Reason: Changed QUOTE tags to CODE tags
# 7  
Old 02-28-2017
Assuming you are using bash...
Longhand, OSX 10.12.3, default bash terminal:-
Code:
Last login: Tue Feb 28 20:19:10 on ttys000
AMIGA:amiga~> ARRAY=( Insert completed. 100 rows added )
AMIGA:amiga~> echo "${ARRAY[2]}"
100
AMIGA:amiga~> _

This assumes that there is always an integer value as the third field.
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