Show transcribed image texte. Pretty-Printing a Data File: Some database and spr

Question

Show transcribed image texte. Pretty-Printing a Data File: Some database and spreadsheet packages can save-files with comma-separated values, (CSVs) as one way to export their data, so other applications can import them for further processing. Given a data file with comma-separated fields, of the form Column labels Full Name, Street Address, City State Zip, Phone Number Jones, Bill, 235 S. Williams St., Denver, CO, 80221, (303) 244-7989 Data line Data line Smith, Tom, 404 Polk Ave., Los Angeles, CA, 90003, (213) 879-5612 Write a shell script to reformat the data and print it out to "stdout" in labeled, evenly-spaced columns as the following example, note the lengths of the label strings in the first line and the maximum string length in each column

e. Pretty-Printing a Data File: Some database and spreadsheet packages can save-files with comma-separated values, (CSVs) as one way to export their data, so other applications can import them for further processing. Given a data file with comma-separated fields, of the form Column labels Full Name, Street Address, City State Zip, Phone Number Jones, Bill, 235 S. Williams St., Denver, CO, 80221, (303) 244-7989 Data line Data line Smith, Tom, 404 Polk Ave., Los Angeles, CA, 90003, (213) 879-5612 Write a shell script to reformat the data and print it out to "stdout" in labeled, evenly-spaced columns as the following example, note the lengths of the label strings in the first line and the maximum string length in each column: Full Name Street Address State Phone Number city Zi Bill Jones 235 S. Williams St. Denver 80221 (303 244-7989 CO Los Angeles CA Tom Smith 404 Polk Ave. 90003 (213 879-5612

Explanation / Answer

# Hello World Program in Bash Shell

FILE="Newfile.txt"
while read line;
do
echo "$line"
cp Newfile1.txt letter-to-$line.txt
sed -i "s/USERNAME/${line}/g" letter-to-$line.txt
done < $FILE

Output

-------------

1. Here Newfile1.txt is notepad file in which i have taken below message

Hi USERNAME,

How are yout !

Thanks,

Admin

2. Newfile.txt has all the person name with line seperator

3. using the cp command we copied the letter contents to file like letter-to-<username>.txt

4. using sed command we replace all the string "USERNAME" with person name and close the file .

5. we performed step 3 and 4 in loop or for number of persons avaibale in Newfile.txt.

Thanks,

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.