Prev: Return empty sparse from a mex file
Next: create a circular neighborhood around a point
From: cabrego on 26 Oct 2009 10:58
Hi all,

I am working on an automatic file import problem.

My program converts binary files into correctly formated data matrices and is suppose to import them into a work sheet with unique worksheet names which are captured in matlab and stored to rename the worksheet.

My problem is that the worksheet names exceeds the excel worksheet name limit which is like 31 or 32 from what I have read online. My file names are about 36 characters long.

Does anyone know of a way I can truncate the file name that I am saving in matlab. It turns out I can ignore the last 13 characters of the file name without ill effects.

I am using dir(FILES(i).name) to store the file name to rename the work sheets.

Thanks
From: someone on 26 Oct 2009 11:08
"cabrego " <cpabrego(a)gmail.com> wrote in message <hc4dec$gk6$1(a)fred.mathworks.com>...
> Hi all,
>
> I am working on an automatic file import problem.
>
> My program converts binary files into correctly formated data matrices and is suppose to import them into a work sheet with unique worksheet names which are captured in matlab and stored to rename the worksheet.
>
> My problem is that the worksheet names exceeds the excel worksheet name limit which is like 31 or 32 from what I have read online. My file names are about 36 characters long.
>
> Does anyone know of a way I can truncate the file name that I am saving in matlab. It turns out I can ignore the last 13 characters of the file name without ill effects.
>
> I am using dir(FILES(i).name) to store the file name to rename the work sheets.
>
> Thanks

% Well, if you can safely ignore the last 13 characters,
% then something like:

newName = name(1:end-13);

% should work.
 | 
Pages: 1
Prev: Return empty sparse from a mex file
Next: create a circular neighborhood around a point