The Directory.txt file contains names of the employees and their phone numbers in the following order.Last name, First name, Phone.The creator of this file made several mistakes by typing commas and dots inconsistently.Write a Python program to read this file and produce an output file with the name DirectoryNew.txt. This file should fomat the phone directory asfollows:PhoneFirst nameNumber 1First name 1Number 2First name 2The file MUST end with:########## End of directory ########## Content of the input fileSpringsteen, Bruce, 2587.Hassan, Amir, 6958.Homes, Rebecca, 5263Smith, John, 5252MacDonald, Mirna, 89651Pichai, Sundar, 9632.Jobs, Steve, 1002Goldsmith, Micheal, 5478.Yassir, Ammar, 8885Nicholas, Jack, 4696Pang, Chee, 9898Lee, Andrew, 7412.Jimenez, Dragos, 6547Edit MetadataThe output should be as followsPhoneFirst name2587Bruce6958Amir5263Rebecca5252John8965Mirna9632Sundar1002Steve5478Micheal8885Ammar4696Jack9898Chee7412Andrew6547Dragos########## End of directory ##########

Answered: The Directory.txt file contains names…

Engineering

Computer Science

The Directory.txt file contains names of the employees ar

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Rename the Team directory to Return to the Boston Celtics directory and create a new directory…

A: First we create a directory cheerleader mkdir cheerleader Then make sub directory inside…

Q: What role does WiFi play in the growth of computers?

A: Computers, tablets, smartphones and other devices can be connected to the internet using Wi-Fi…

Q: ls" command to list ALL the contents of a directory in long format, sorted in reverse by last…

A: "ls" command to list ALL the contents of a directory in long format, sortedin reverse by last…

Q: Give specifics about the file handle.

A: Answer is in next step.

Q: Executing an UPDATE statement will return______. the number of records updated the set…

A: UPDATE Statement: The UPDATE statement is used to update records in a table. Syantx: UPDATE…

Q: Will the operator filetype:log return the results of log files?

A: The filetype operator helps to find the target page with the help of extensions. For example,…

Q: D.Merge the data in your Stata window with the file part_education using phid as the unique…

A: Answer D: We assume that we have a file,we use merge one to one merge with identifier as phid in…

Q: Given the variable names pathName contains a string describing a directory path, write a statement…

A: Note- since programming language is not specified we providing answer in python programming. Answer…

Q: If you don't know where the update.txt file is located on your computer, print one сорy.

A: For the Purpose of Locating a File: Using the following procedures, if you don't know where a file…

Q: Give specifics about the file handle.

A: A file is a common storage device for computers, and all programs and data are "written" to and…

Q: If you can't remember where the update.txt file is on your machine, print it out.

A: As a subject matter expert, I understand that locating a specific file on a computer system can…

Q: The following command will reveal which files: cat *file*

A: Intro Given, Command: cat *file*

Q: If a file can not be opened, the command fopen will return

A: fopen opens the specified file in the particular mode. Example : fp = fopen("file.txt","r"); In…

Q: If you do not know the location of the update.txt file on your computer, print a copy.

A: Here we have given complete solution to know the location of update.txt file and print the text…

Q: Give specifics about the file handle.

A: File handle: A file handle is a temporary reference number that is issued by an operating system to…

Q: If you don't know where the update.txt file is located on your computer, print one copy.

A: To locate the file's location, Whenever you don't know the location of a file but you know its name,…

Q: What is the default folder in which the ISO file will be stored when it is created automatically?

A: ISO : In addition to ISO file, ISO image is also used. It is common to utilize ISO images to…

Q: Give specifics about the file handle.

A: When one stores some data on a file with the help of a program then it is known as File handling.

Q: The names Sam, Tom, Bill, and so on are in the same group as you. The permissions column on a file…

A: To discuss who has the access to a file answer with value on permission column is ----r-----.

Q: Instructions Write a program to implement the algorithm that you designed in Exercise 20 of Chapter…

A: #include<iostream.h>#include<bits/stdc++.h>int main(){ float accBalance;float…

Q: the command that will delete all the records in the table "Books" is .a DELETE ROWS FROM Books; .b O…

A: The Delete statement removes one or more rows in a table permanently. The syntax of the Delete…

Q: In case you can't remember where you put the update.txt file, write it down.

A: In case you cannot remember where you placed the "update.txt" file, you can apply your operating…

Q: 1. What is a file?

A: The above question that is what is a file is answered in below step.

Q: If you do not know where the update.txt file is located on your computer, print a copy.

A: For Locating File Location If you just know the file's name and not its location, you may still…

Q: Give specifics about the file handle.

A: The answer of this question is as follows:

Q: SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: The__________ control contains buttons for moving from one record to anotherin a dataset.a.…

A: Binding Navigator controls has the buttons which are used in moving from one record to another.…

Q: Give specifics about the file handle.

A: File name: A temporary reference number known as a "file handle" is given to a file by an operating…

Q: The final result of "records.txt" file will look something like this (depending on the number of…

A: creating_records.py from calculating_average import * name_list= [] courselist = [] nostd =…

Q: Create the function that would allow you to add information about students (name, surname, field of…

A: Since you have not asked for any particular language. So i am answering the question in c++. in next…

Q: Given the variable names pathName contains a string describing a directory path, write a statement…

A: Note- since programming language is not specified we providing answer in python programming. Answer…

Q: If you don't know where the update.txt file is on your machine, you should print a duplicate.

A: Intro For Finding File Location: When you do not know the location of a file but know its name, you…

Q: Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include…

A: Solution a) Go to cell C10 enter the following formula =AVERAGE(C8:C9)

Q: ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: This option in the COPY command treats the first row of a file as column names (all uppercase, no…

A: We need to find if the copy command treats first row of a file as column names or not.

Q: If you do not know where the update.txt file is located on your compute

Q: close all; clear all; clc; current_script = mfilename('fullpath'); script_directory =…

A: The scenario involves a MATLAB script designed for data analysis and curve fitting. It begins by…

Q: The file name is file1.txt How would you inclue this?

A: The answer is given below.

Q: If the record pointer is positioned on record number 2 in a dataset, which of the following will…

A: Explanation: The “Position” Property and the “Move()” method can be used to position the record…

Question

The Directory.txt file contains names of the employees and their phone numbers in the following order.
Last name, First name, Phone.
The creator of this file made several mistakes by typing commas and dots inconsistently.
Write a Python program to read this file and produce an output file with the name DirectoryNew.txt. This file should fomat the phone directory as
follows:
Phone
First name
Number 1
First name 1
Number 2
First name 2
The file MUST end with:
########## End of directory ##########

Content of the input file
Springsteen, Bruce, 2587.
Hassan, Amir, 6958.
Homes, Rebecca, 5263
Smith, John, 5252
MacDonald, Mirna, 89651
Pichai, Sundar, 9632.
Jobs, Steve, 1002
Goldsmith, Micheal, 5478.
Yassir, Ammar, 8885
Nicholas, Jack, 4696
Pang, Chee, 9898
Lee, Andrew, 7412.
Jimenez, Dragos, 6547
Edit Metadata
The output should be as follows
Phone
First name
2587
Bruce
6958
Amir
5263
Rebecca
5252
John
8965
Mirna
9632
Sundar
1002
Steve
5478
Micheal
8885
Ammar
4696
Jack
9898
Chee
7412
Andrew
6547
Dragos
########## End of directory ##########

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Using Binsort and keys between 0 and 999, Binsort has to make _____ passes to sort the records. a. 1 b. 2 c. 3 d. 4
Give specifics about the file handle.
New records are saved at the end of the file. This refers to: O Ordered Files. O Hash Files. O Unordered Files.
Write a C program in simtee.c that is a simplified version of tee. It should take exactly one argument () and, using system calls, copy the standard input to the stan- dard output as well as to outfile. If outfile already exists, it should be overwritten; the file should be created if it does not exist. Note: Multiline input is allowed. The user should use Ctr+D to indicate end of input.
The given text files represent a list of account numbers and associated balances. Balances change over time. If a balance is later in the file, then this implies the balance for that customer is more recent. Ask the user for a file name then display the most recent balance along with the high and low balance. balances-0.txt customer id balance1 $93.831 $805.242 $866.454 $943.283 $764.121 $798.004 $395.595 $644.264 $18.314 $814.97
I have to create a database using python to show geographical points. Create a program the will create your database and insert at least five points. Use your own data, something like: 100, 200, 123, Main Campus 120, 133, 142, Montoya 153, 123, 322, Rio Rancho 133, 123, 143, STEMULUS Center 153, 142, 122, ATC Run your initialization code to create the database.
Computer orzgination
If you do not know where the update.txt file is located on your computer, print a copy.
Give specifics about the file handle.
If you do not know where the update.txt file is located on your computer, print a copy.
| 1. What is a file?