Question

Ruby Assignment - Text file format conversion: Write a program that will take a text file with lines in this format:

Last_name:First_name:Number_of_cats:Number_of_dogs:Number_of_fish:Number_of_other_pets

and produce a text file with lines in this format:

First_name Last_name:Total_number_of_pets

For example, if the original text file looks like this:

Chawla:Kalpana:0:0:3:0
Davis:Jo Ann:0:0:5:2
de Vries:Gustav:3:1:0:1
Goldberg:Adele:2:1:1:0
Noriega:Carlos:2:2:0:0
Ride:Sally:0:1:0:2
Turing:Alan:0:0:0:0

the new text file should look like this:

Kalpana Chawla:3
Jo Ann Davis:7
Gustav de Vries:5
Adele Goldberg:4
Carlos Noriega:4
Sally Ride:3
Alan Turing:0

Note that first and last names can contain spaces. The delimiter between fields in the original file will be colon (:), not space.

Answer 1

The code for the above problem is below:

# we loop through each line in our input text File

# i.e data.txt

File.foreach("data.txt") {

|line|

a= line.split(':') # we split the line based on : as deliminter

name=a[1]+" "+a[0] # index 1 has first name and 0 last name

# converting number to int and summing the pets

sum_pets=a[2].to_i+a[3].to_i+a[4].to_i+a[5].to_i

# writing the result in new file result.txt

File.write("result.txt", name+":"+sum_pets.to_s+"\n", mode: "a")

}

CODE SCREEN SHOT

INPUT FILE- The input file name is data.txt contains data as given in the question.

Output file- The output is stored in result.txt. you are not required to create this file it will be automatically created when the program is executed. This file is opened in append mode i.e "a". which means it will the append output at the end. So, if you run your program multiple times results will be appended multiple times in the file.