Creating a MATLAB Matrix from ISP Connections

[Stoccardo]

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

 

[jono]

Look up textread, fscanf and xlsread :)

 

[raining Pete]

Hello Stoccardo,

I can help you with importing and forming a matrix in MATLAB for your internet service provider connections. First, you will need to use the "importdata" function to import your txt or xls file into MATLAB as a matrix. This function will automatically detect the delimiter used in your file (in this case, it seems to be a tab) and create a matrix with the data.

Next, you will need to use the "cellstr" function to convert the first two columns (City1 and City2) into cell arrays. This will allow you to manipulate the data more easily and create a new matrix with the connections.

Here is an example code:

% Import the data
data = importdata('yourfile.txt');

% Convert the first two columns into cell arrays
city1 = cellstr(data(:,1));
city2 = cellstr(data(:,2));

% Create a new matrix with the connections
connections = [city1 city2];

% Display the connections
disp(connections);

I hope this helps! Let me know if you have any further questions.