using the Xlsread functon

hello! i used the function xlsread to do that:

 [num,txt]=xlsread(nameoffile,'C:C')

then

 txt(indice,1)='xxxxxxxxxxxxx'

so, when i do that:

 FileName =txt(indice,1)

==> the result is :

 FileName= 'xxxxxxxxxxxx'

but me, i want to do that: FileName='xxxxxxxxxxxx' ==> FileName=xxxxxxxxxxxx in order to use FileName in my script

[Geoff Hayes]

Ahmed - since FileName is a string of characters it will be wrapped in single quotes. Why would you want it without the quotes? How are you using this variable in your code?

[Ahmed BOULMANE]

i want to use it to build a file name: using that : name = ['txt file\',FileName,'.txt']

[Ahmed BOULMANE]

So I need another function that can give me the possibility to use the texts that I recovers from the excel file as normal texts

Answer 1

[Brendan Hamm]

The issue is that txt is a cell array which contains char-arrays. So you need to use curly brackets to extract the character array back out.

FileName = txt{indice,1} % Curly Brackets! 
name = ['txt file\',FileName,'.txt']

[Brendan Hamm]

Sorry, almost missed the fact that:

txt(indice,1)='xxxxxxxxxxxxx'

is an invalid statement. You need curly brackets here too.

txt{indice,1}='xxxxxxxxxxxxx'

[Ahmed BOULMANE]

thank You :)