MATLAB Creating a MATLAB Matrix from ISP Connections

Click For Summary
The discussion centers on importing data from a text or Excel file into MATLAB to create a matrix representing internet service provider connections. The user seeks assistance in structuring the data, where each connection is defined as a link between two cities (City1 to City2). An excerpt from the file is provided, showing various connections and their corresponding providers. Suggestions include using MATLAB functions such as textread, fscanf, and xlsread to facilitate the import process and organize the data into the desired matrix format.
Stoccardo
Messages
1
Reaction score
0
hello everyone!
perhaps I am right here. i need help with programming MATLAB. i ve got a txt (or alternatively a xls) file. stored in it are internet service provider connections. i want to import this file and form a matrice. in this initial matrice each connection should be shown (a connection is city1 --> city2). below is a _small_ excerpt of the file i have.
help is really appreciated.
/Stoccardo

Rk City1 City2 Provider
84 Ealing, UnitedKingdom Ilford, UnitedKingdom Brit.Telecom
85 Ealing, UnitedKingdom Glasgow, UnitedKingdom Brit.Telecom
86 Kingston, UnitedKingdom Ilford, UnitedKingdom Brit.Telecom
87 Bletchley, UnitedKingdom Milan, Italy Brit.Telecom
88 Ealing, UnitedKingdom Santa Clara, CA Brit.Telecom
89 Ealing, UnitedKingdom Dallas, TX Brit.Telecom
90 Paris, France London, UnitedKingdom Colt
91 London, UnitedKingdom Caracas, Venezuela Colt
92 Paris, France Berlin, Germany Colt
93 London, UnitedKingdom Dublin, Ireland Colt
94 London, UnitedKingdom Barcelona, Spain Colt
 
Physics news on Phys.org
Look up textread, fscanf and xlsread :)