Editing phone number with multiple delimiters Post: 302770624

Sponsored Content

Top Forums Shell Programming and Scripting Editing phone number with multiple delimiters Post 302770624 by smartSometimes on Sunday 17th of February 2013 03:22:32 PM

02-17-2013

Registered User

Editing phone number with multiple delimiters

Hello all
I have a data base of information that is formatted like so:
JSD4863 XXX-XX-XXXX DOE, JOHN C JR-II BISS CPSC BS INFO TECH 412/779-9445

I need the last four digits of the phone number. However, many lines contain
'garbage data' that I'm not interested in. So i used a 'for loop' to specify
which lines i wanted. The code looks like this:

Code:

#!/bin/bash
for linePosition in {11..22}
        do
                holder=`sed -n "${linePosition}p" $1|awk '{print $12}'` 
                echo "$holder"
        done

This gives me the 11 lines that I want. However, it gives me the full phone
number. I want to ALSO pipe this command to only give me the last 4 digits.
I am not sure how to do this since the fields are delimited by two different
characters. I tried a couple variations of cut, but nothing work.
Please help

Last edited by vgersh99; 02-17-2013 at 05:49 PM.. Reason: corrected code tags

smartSometimes

View Public Profile for smartSometimes

Find all posts by smartSometimes

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to count number of delimiters in a file name

I have a list of files with names as "FULL_abcd_xyz_timestamp.txt" and "FULL_xx_abcd_xyz_timestamp.txt". I am writing a script with a 'for loop' to take each file, strip the "FULL" and "timestamp" from the file name and do some actions on the contains of the file. So I need to know the number of...

2. UNIX for Dummies Questions & Answers

Script to find the number of tab delimiters in a line

Hi, I need to find the number of tab delimiters in the first line of a file.So using word=`head -1 files.txt` I have extracted the first line of file into a variable word.It has 20 tab delimted columns.So can anyone help me in finding the number of delimiters? I am using csh and I am a...

3. Shell Programming and Scripting

Perl script :- Phone number validation

Hi All, I am doing a perl script validation for Phone numbers. The normal phone number format is 01-32145. I need to do two validations for the phone number 1) A valid phone number can have at least two digits as prefix and at least five digits as postfix. e.g. 01-01011 2) A...

4. Shell Programming and Scripting

AWK with multiple delimiters

I have the following string sample: bla bla bla bla bla I would like to extract the "123" using awk. I thought about awk -F"]" '{ print $1 }' but it doesn't work Any ideas ?

5. Shell Programming and Scripting

Sorting problem: Multiple delimiters, multiple keys

Hello If you wanted to sort a .csv file that was filled with lines like this: <Ticker>,<Date as YYYYMMDD>,<Time as H:M:S>,<Volume>,<Corr> (H : , M, S: ) by date, does anybody know of a better solution than to turn the 3rd and 4th colons of every line into commas, sorting on four keys,...

6. Shell Programming and Scripting

Concatinating the lines based on number of delimiters

Hi, I have a problem to concatenate the lines based on number of delimiters (if the delimiter count is 9 then concatenate all the fields & remove the new line char bw delimiters and then write the following data into second line) in a file. my input file content is Title| ID| Owner|...

7. Shell Programming and Scripting

Getting phone number, its message and assigning them into 2 variables then screen output.

Hi Everyone, I have a flatfile "inbox.txt" which contains some information: Location 0, folder "Inbox", SIM memory, Inbox folder SMS message SMSC number : "+24800000023" Sent : Sat 04 Aug 2012 09:01:00 PM +0700 Coding : Default GSM alphabet...

8. Shell Programming and Scripting

awk multiple delimiters

Hi Folks, This is the first time I ever encountered this situation My input file is of this kind cat input.txt 1 PAIXAF 0 1 1 -9 0 0 0 1 2 0 2 1 2 1 7 PAIXEM 0 7 1 -9 1 0 2 0 1 2 2 1 0 2 9 PAKZXY 0 2 1 -9 2 0 1 1 1 0 1 2 0 1 Till the sixth column (which is -9), I want my columns to...

9. Shell Programming and Scripting

Count The Number Of Delimiters using awk or better

What to know the way to count the number of delimiters in each record by ignoring the escape delimiters. Sample Data: 12345678|ABN\|XYZ MED CHEM PTY. LTD.|C||100.00|22|AB"C\|Corp|"XYZ|CDEF"| I'm using awk -F'|' '{ print NF-1 }' command to find the number of delimiters. this command...

10. Web Development

Auto phone number search

Hi. I want to search 10 phone numbers automatically in Facebook and store the result in some format. Can anyone help me with the script. I am using kali Linux.

LEARN ABOUT DEBIAN

phones

phones(4)							   File Formats 							 phones(4)

NAME

       phones - remote host phone number database

SYNOPSIS

       /etc/phones

DESCRIPTION

       The  file /etc/phones contains the system-wide private phone numbers for the tip(1) program. /etc/phones is normally unreadable, and so may
       contain privileged information.	The format of /etc/phones is a series of lines of the form:

       <system-name>[ 	]*<phone-number>.

       The system name is one of those defined in the remote(4) file and the phone number is constructed from [0123456789-=*%]. The  `='  and  `*'
       characters  are	indicators  to	the auto call units to pause and wait for a second dial tone (when going through an exchange).	The `=' is
       required by the DF02-AC and the `*' is required by the BIZCOMP 1030.

       Comment lines are lines containing a `#' sign in the first column of the line.

       Only one phone number per line is permitted. However, if more than one line in the file contains the same system name tip(1)  will  attempt
       to dial each one in turn, until it establishes a connection.

FILES

       /etc/phones

SEE ALSO

       tip(1), remote(4)

SunOS 5.10							    14 Jan 1992 							 phones(4)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to count number of delimiters in a file name

Discussion started by: ayanbiswas

2. UNIX for Dummies Questions & Answers

Script to find the number of tab delimiters in a line

Discussion started by: poornimajayan

3. Shell Programming and Scripting

Perl script :- Phone number validation

Discussion started by: subin_bala

4. Shell Programming and Scripting

AWK with multiple delimiters

Discussion started by: gdub