Capturing a number at the end of line and store it as variable


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Capturing a number at the end of line and store it as variable
# 1  
Old 11-25-2008
Capturing a number at the end of line and store it as variable

Hello, Would someone guide me on how to write a shell script the would search for a phone no using at the end text file using sed or awk and store it in a varaible or print it.

The text file is in this form

text or numbers in first line
text or numbers in second line
.
.
.
Firsname Lastname:KEN:+254456789

The first lines may take any form but the last line will always be
of the form "Firstname Lastname:KEN:+254456789"
I would like to seach for the Phone and store it in a variable and print it.
The phone no will alway be preceeded by ":+"

Thank you in advance
# 2  
Old 11-25-2008
sample file: test
---------------------------
text or numbers in first line
text or numbers in second line
.
.
.
Firsname Lastname:KEN:+254456789
------------------------------------

> phonenum=`tail -1 test | cut -d"+" -f2`
> echo $phonenum

this can be done in a loop for number of files .

for i in `ls textfiles*`
do
phonenum=`tail -1 $i | cut -d"+" -f2`
echo $phonenum
done
# 3  
Old 11-26-2008
Thank you mk1216.

The code worked. I one day old in regards to working with awk and sed. Would explain what tail -1 test | cut -d"+" -f2 means. Also how do I append the + back when assigning the results of tail -1 test | cut -d"+" -f2 to variable $phonenum.

Thank you again for the help you have given.
# 4  
Old 11-26-2008
new code

Quote:
Originally Posted by mk1216
sample file: test
---------------------------
text or numbers in first line
text or numbers in second line
.
.
.
Firsname Lastname:KEN:+254456789
------------------------------------

> phonenum=`tail -1 test | cut -d"+" -f2`
> echo $phonenum

this can be done in a loop for number of files .

for i in `ls textfiles*`
do
phonenum=`tail -1 $i | cut -d"+" -f2`
echo $phonenum
done
for i in `ls textfiles*`
do
phonenum=`tail -1 $i | cut -d":" -f3`
echo $phonenum
done

Try this , now $phonenum should have + as well !
# 5  
Old 11-26-2008
Previous code holds good only if your data file's last line is always in this format :

"Firsname Lastname:KEN:+254456789"
# 6  
Old 11-26-2008
Thanks mk1216.
Works.
Please explain how
phonenum=`tail -1 number.txt | cut -d"+" -f2`
get the number in add the plus.

Thanks Again.
# 7  
Old 11-26-2008
Try this:

phonenum=+`tail -1 number.txt | cut -d"+" -f2`
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash to match and store line as variable

The bash below loops through a specific directory dir and finds and writes the oldest folder to a variable called $filename. #!/bin/bash # oldest folder stored as variable for analysis, version log created, and quality indicators matched to run dir=/home/cmccabe/Desktop/NGS/test find... (2 Replies)
Discussion started by: cmccabe
2 Replies

2. Shell Programming and Scripting

How to read a file line by line and store it in a variable to execute a program ?

Hello, I am quite new in shell scripting and I would like to write a little scritp to run a program on some parameters files. all my parameters files are in the same directory, so pick them up with ls *.para >>dirafter that I have a dir file like that: param1.para param2.para etc... I... (2 Replies)
Discussion started by: shadok
2 Replies

3. Shell Programming and Scripting

Get line of textfile and store it in variable

Hi! I need to do the following: (1) I wan't to extract a line of a textfile (defined by a numer) and store it into a variable... (2) ...but I want to cut out a part of the line which is between two tokens and store just this to the variable Example: BlaBlaBla Bla2Bla2Bla2 *pPointerOne;... (4 Replies)
Discussion started by: Michi21609
4 Replies

4. Shell Programming and Scripting

capturing a file to store in a variable

I have a file in a windows directory the file is delivery to us like this 07210900.dat where 07210900 is the current date. If I want to store that file in a variable UpLoadFileName and rename, so I can Ftp later to a UNIX directory, I am doing this, is this correct? CDRemoteDir='cd... (0 Replies)
Discussion started by: rechever
0 Replies

5. UNIX for Dummies Questions & Answers

Using GREP/AWK to extract a number and store it as a variable

Hello, I have a question regarding the awk command. Here is the line I need to grep: 1 F= -.13250138E+03 E0= -.13249556E+03 d E =-.174650E-01 mag= 35.2157 Instead of displaying the number in red I would like to store it as a variable such as X. Is there a way to do this? Thanks for any... (3 Replies)
Discussion started by: modey3
3 Replies

6. Shell Programming and Scripting

ksh: How to store each output line into a different variable?

Example output: /tmp/generatelines.sh line1 line2 line3 line4 I want each output line assigned to its own variable, ie: "line1" --> $a "line2" --> $b "line3" --> $c "line4" --> $d Is this possible without writing to a temporary file? Thanks (4 Replies)
Discussion started by: ksheller
4 Replies

7. Shell Programming and Scripting

store the first line of a file in a variable

i have to store the files in a folder and assign a variable to the the files. (0 Replies)
Discussion started by: dineshr85
0 Replies

8. Solaris

Need help capturing end of line numbers

Hello All, Currently I am attempting to write a script which will capture a number at the end of a line. The line which I am searching through ends as follows: word word=number for example word word=3 OR word word=15 I am stuck on how to capture whatever is to the right... (3 Replies)
Discussion started by: icalderus
3 Replies

9. UNIX for Dummies Questions & Answers

Read and store each line of a file to a variable

Hi all, I'm quite new to unix and hope that someone can help me on this. I'm using csh. Below is what i intend to do. 1. I stored some data in a file. 2. I intend to read the file line by line and store each line of data into a variable, so that i can used it later. Anyone have any... (4 Replies)
Discussion started by: seijihiko
4 Replies

10. UNIX for Advanced & Expert Users

What is the Maximum number of characters that i can store in a variable?

Hi, Can any one tell me, what is the maximum number of characters that can be stored in a variable? Thanks in Advance, Shan (9 Replies)
Discussion started by: pcshan
9 Replies
Login or Register to Ask a Question