Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

telephonefile_P2: The pointy-haired manager's secretary, Pat, keeps a telephone directory for him. But Pat mixes up local phone numbers, long distance phone numbers, and even

telephonefile_P2:

image text in transcribed

The pointy-haired manager's secretary, Pat, keeps a telephone directory for him. But Pat mixes up local phone numbers, long distance phone numbers, and even international numbers in it. Worse, Pat has no common method of entering numbers, some area codes are surrounded by ( ), some are not. Some numbers have a space between them, others a dash. The pointy-hair manager only wants to see the file with the names and their North American number plan numbers in it the familiar seven digit number. (Those are numbers that end with 3 numbers, a space or dash, and then 4 numbers). Work out a command structure that can be issued to the file telephonefile_P2, that returns the following:

Sam Spade (212)-756-1045

Daffy Duck 312 450 2856

Mom 354-2015

Lolita Spengler (816) 756 8657

Dr. Harold Kranzler 765-986-9987

Ralph Spoilsport's Motors 967 882 6534

Sister Sue 978 0672

JCCC 913-469-8500

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions