I need help creating a Java program that is described in the given image and description below: The attached text file contains record information from records with the following field format: first name,middle name,last name,city name The data was badly stored, using the Comma Separated Value (CSV) format, in such a way that the fields do not properly align with that record format. All of the information is there but the record boundaries are mis-aligned. Some, all, or more than a single proper record may exist in as a single record in this file. Example: Lars Jame,Thompson,Clifton,Jenifer Mae,Jones,Henry Rick,Luke,Simons Lincoln,Tim,Lee,Huag,Boston Sally,Joe,Patton,New York Howard,Richard,Larson,Scramento,Samantha,Austin,Henry,St George,George Henry,Marcus,New Town Your task is to write a program that will read the data from bad files and write new files with the data correctly stored in a new CSV format and in alphabetical order by last name, first name, middle name. The new format is: last name,first name,middle name,city name The correctly written final file: Henry,Samantha,Austin,St George Huag,Tim,Lee,Boston Jones,Jenifer,Mae,Henry Larson,Howard,Richard,Scramento Marcus,George,Henry,New Town Patton,Sally,Joe,New York Simons,Rick,Luke,Lincoln Thompson,Lars,Jame,Clifton Note that your program should handle any file that contains any number of lines of data, as long as all of the information is available for each record. If you use the Scanner class to read your files field data you should set the Scanner object’s delimiter using the regular expression “[,\n\r]+”. This will allow it to properly read the End-Of-Record markers for each line in the file. To easily sort the records, I recommend storing each record’s data into a class object that holds the first name,middle name,last name,city name fields. You can then write a compareTo() method that will allow you to sort the objects.
I need help creating a Java program that is described in the given image and description below:
The attached text file contains record information from records with the following field format:
first name,middle name,last name,city name
The data was badly stored, using the Comma Separated Value (CSV) format, in such a way that the fields do not properly align with that record format. All of the information is there but the record boundaries are mis-aligned. Some, all, or more than a single proper record may exist in as a single record in this file.
Example:
Lars
Jame,Thompson,Clifton,Jenifer
Mae,Jones,Henry
Rick,Luke,Simons
Lincoln,Tim,Lee,Huag,Boston
Sally,Joe,Patton,New York
Howard,Richard,Larson,Scramento,Samantha,Austin,Henry,St George,George
Henry,Marcus,New Town
Your task is to write a program that will read the data from bad files and write new files with the data correctly stored in a new CSV format and in alphabetical order by last name, first name, middle name. The new format is:
last name,first name,middle name,city name
The correctly written final file:
Henry,Samantha,Austin,St George
Huag,Tim,Lee,Boston
Jones,Jenifer,Mae,Henry
Larson,Howard,Richard,Scramento
Marcus,George,Henry,New Town
Patton,Sally,Joe,New York
Simons,Rick,Luke,Lincoln
Thompson,Lars,Jame,Clifton
Note that your program should handle any file that contains any number of lines of data, as long as all of the information is available for each record.
If you use the Scanner class to read your files field data you should set the Scanner object’s delimiter using the regular expression “[,\n\r]+”. This will allow it to properly read the End-Of-Record markers for each line in the file.
To easily sort the records, I recommend storing each record’s data into a class object that holds the first name,middle name,last name,city name fields. You can then write a compareTo() method that will allow you to sort the objects.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps