hi i would like to know how can I checked the name of a file and then retrieve only the first 6 characters.
the format of the file names is: dd1234_10x2.xsl
i need to get just the first 6 characters up to the underscore, but if the name of the file does not contain an underscore after the first 6 chars, i.e. dd1234.10x10.xsl
then i need to skip that file and continue to the next file on that folder.
i hope this is clear.