Each line of the file UN.txt contains four pieces of information (name, continent, population in millions, area) about one of the 192 member countries of the United Nations. The first two lines of the file are
Afghanistan,Asia,28.2,251772
Albania,Europe,3.2,11100
What is the first line of the file created by the following code? Dim query = From line In IO.File.ReadAllLines("UN.txt") Let data = line.Split(","c)
Let country = data(0)
Let population = 1000000 * CDbl(data(2))
Select country & "," & population
IO.File.WriteAllLines("NewFile.txt", query)
A) Afganistan,28.2
B) Afganistan,28,200,000
C) Afganistan,28200000
D) country,population

Question

Each line of the file UN.txt contains four pieces of information (name, continent, population in millions, area) about one of the 192 member countries of the United Nations. The first two lines of the file are 
Afghanistan,Asia,28.2,251772
 Albania,Europe,3.2,11100 
What is the first line of the file created by the following code? Dim query = From line In IO.File.ReadAllLines("UN.txt") Let data = line.Split(","c) 
Let country = data(0) 
Let population = 1000000 * CDbl(data(2)) 
Select country & "," & population 
IO.File.WriteAllLines("NewFile.txt", query)
A) Afganistan,28.2
B) Afganistan,28,200,000
C) Afganistan,28200000
D) country,population

Quizplus · Accepted Answer

The code reads the UN.txt file, splits each line by the comma character, then calculates the population in millions by multiplying the third element by 1 million. Finally, it selects the country name and population separated by a comma. Therefore, the first line of the new file will contain "Afghanistan,28200000".

Each Line of the File UN