Thread Subject: problem in reading comma delimited data array

Subject: problem in reading comma delimited data array

From: soms.sharma@gmail.com

Date: 4 Jan, 2009 23:52:01

Message: 1 of 3

Hi,

I have to read comma delimited array data with nonuniform
rows,columns. I just needed to read these data into single array A.
I did like this:

A=dlmread(filename, ',' )

but this does not displays all data and introduces unwanted zeros.
What I need is just in the form of continous array.
A(1)=1157
A(2)=1088
....

A(n)=957

Could you please suggest how to accomplish this task?

1157,1088,1169,1169,984,1322,1178,1103,1211,1292,
1124,
1171,1133,
1227,1142,1216,1259,1299,1232,1117,1155,
1232,1083,1020,1394,1196,1148,1083,1189,1133,1034,
1157,1034,1097,1299,1157,1130,1155,1349,1232,1103,
1103,1083,1027,1166,1148,1250,1155,1047,1054,1018,
1189,1126,1250,1297,1178,1043,1103,1250,1272,1169,
1004,1083,1164,1124,1027,995,1169,1270,1011,1247,
1101,1004,1004,1065,1223,1184,1216,1180,1142,1277,
1206,1076,1076,1189,1121,1178,1031,1076,1178,1209,
1022,1220,1070,1126,1058,1216,1358,1184,1083,1097,
1119,1097,1097,1153,1153,1151,1151,1151,1184,1097,
1043,1043,1002,1152,1097,1034,1002,989,1092,1115,
1115,1047,1040,1038,1085,1126,1058,1067,1115,1263,
1124,1110,1097,1097,1157,1000,991,995,1013,1007,
971,971,980,993,1043,1097,982,971,971,1065,
1022,1029,989,1029,995,982,1090,980,971,957

Subject: problem in reading comma delimited data array

From: Phil Goddard

Date: 5 Jan, 2009 00:34:02

Message: 2 of 3


One possibility:

data = fileread('nameOfMyDataFile.txt');
data(data==char(10)) = []; %get rid of newline characters
data(data==char(13)) = []; %get rid of carriage returns
data = str2num(data)'; % convert to a column of numeric data

Phil.

Subject: problem in reading comma delimited data array

From: Jiro Doke

Date: 5 Jan, 2009 00:55:02

Message: 3 of 3

soms.sharma@gmail.com wrote in message <cfb037ff-f11b-4d59-b97d-261e9a0a84bc@n33g2000pri.googlegroups.com>...
> Hi,
>
> I have to read comma delimited array data with nonuniform
> rows,columns. I just needed to read these data into single array A.
> I did like this:
>
> A=dlmread(filename, ',' )
>
> but this does not displays all data and introduces unwanted zeros.
> What I need is just in the form of continous array.
> A(1)=1157
> A(2)=1088
> ....
>
> A(n)=957
>
> Could you please suggest how to accomplish this task?
>
> 1157,1088,1169,1169,984,1322,1178,1103,1211,1292,
> 1124,
> 1171,1133,
> 1227,1142,1216,1259,1299,1232,1117,1155,
> 1232,1083,1020,1394,1196,1148,1083,1189,1133,1034,
> 1157,1034,1097,1299,1157,1130,1155,1349,1232,1103,
> 1103,1083,1027,1166,1148,1250,1155,1047,1054,1018,
> 1189,1126,1250,1297,1178,1043,1103,1250,1272,1169,
> 1004,1083,1164,1124,1027,995,1169,1270,1011,1247,
> 1101,1004,1004,1065,1223,1184,1216,1180,1142,1277,
> 1206,1076,1076,1189,1121,1178,1031,1076,1178,1209,
> 1022,1220,1070,1126,1058,1216,1358,1184,1083,1097,
> 1119,1097,1097,1153,1153,1151,1151,1151,1184,1097,
> 1043,1043,1002,1152,1097,1034,1002,989,1092,1115,
> 1115,1047,1040,1038,1085,1126,1058,1067,1115,1263,
> 1124,1110,1097,1097,1157,1000,991,995,1013,1007,
> 971,971,980,993,1043,1097,982,971,971,1065,
> 1022,1029,989,1029,995,982,1090,980,971,957

You can use TEXTSCAN:

>> fid = fopen(filename);
>> d = textscan(fid, '%f', 'delimiter', ',');
>> d = d{1};

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
textscan Jiro Doke 4 Jan, 2009 19:55:04
rssFeed for this Thread
 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com