Extract number from string.


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract number from string.
# 1  
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  
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  
Code:
echo 'Insert completed. 100 rows added ' | awk '{print $(NF-2)}'

# 4  
So - punctuation chars and space remain? Where did you get the [:alpha:] character class?
# 5  
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  
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  
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 for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #52
Difficulty: Easy
A magnetic disc array is an example of offline storage.
True or False?

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

Featured Tech Videos