I have a 12 columns and 50 rows csv file as follows:
Code:
usa city,losangels,sanfran,denver,chicago,boston,newyork,miami
losangels,---, 1500,134,1470,123,456,234
sanfran,1500,---,456,780,3456,768,567
.
.
They are USA cities with distances to each other.
I want to parse it so it looks like this and it will go row by row, maybe output it to text file
Code:
totaldistance["losangels"]tonextcity("losangels", ---));
totaldistance["losangels"]tonextcity("sanfran", 1500));