i have data in database in this format 1,2,3,4,5. and when it fetch it through query it returns [1x9 char]

how can i convert it into original data.

[the cyclist]

It is very difficult to help you with more details. Remember, the only things we know about your problem are what you tell us.

Here are some of the things that would help to know:

• What type of database is it?
• What is the variable type in the database?
• Is that data all from one column, or from 5 columns?
• What is the query you used?

[Ali Asad]

the data is in one column. and i used the following query query = 'select XTermination from Image'; % XTermination is column name curs = exec(con, query); curs=fetch(curs); curs.Data %to display data

Answer 1

[the cyclist]

It seems that in the database, is the variable XTermination of type "character".

If so, then MATLAB is simply reading that character string in, and that is the original data.

For this simple case, you might be able to convert it as follows:

numberList = str2num(curs.Data)

[Ali Asad]

thanks. it wroks

[the cyclist]

For the sake of future users seeking similar answers, please accept the answer, then.