Regular expression in matlab with [,]

Question

I am reading a csv file in matlab as follows.

data_f = fopen(fileName,'r');
while(~feof(data_f))
    line_f = fgetl(data_f);
    Temp(1,:) = regexp(line_f, ',', 'split');
end

My problem is some of the columns in a row has [a,b] format data. So when I try to use regular expression with only ',' as the delimiter it throws as error. So how should i write the regular expression for this purpose.

e.g: CSV file values are

12,23,a,3,[1,2],5

I need as follows

12 23 a 3 [1,2] 5

and not like this

12 23 a 3 1 2 5

Not exactly a duplicate, but my own question may be useful. stackoverflow.com/questions/545584/… — Nzbuu
there are multiple regex questions for dealing with CSV files while ignoring commas if they are contained inside quotations (you have brackets instead of quotes, but its basically the same idea): stackoverflow.com/q/1189416, stackoverflow.com/q/632475, stackoverflow.com/q/639264, stackoverflow.com/q/2170184 — Amro

Hoogendijk Hoogendijk · Accepted Answer · 2011-10-20T03:49:26

The following code will dissect the string s='3,4,[5,6],a,2'

s='3,4,[5,6],a,2'
bracket=false;
i=1;
A=[];

while ~isempty(s)
  if s(i)==',' && bracket==false
    A(end+1)=s(1:i-1);
    s(1:i)=[] 
    i=1; 
  end 
  if s(i)=='[' 
    bracket=true; 
  end 
  if s(i)==']'
    bracket=false; 
  end 
  i=i+1; 
  if i>length(s) 
    i=i-1; 
    A(end+1)=s(1:i);
    s(1:i)=[]; 
  end 
end

-edit after rereading your question-

Regular expression in matlab with [,]

3 Answers

file.csv

MATLAB