I'm not sure you're right about that, Jason. In the referenced article, 260 is given as the default value of the variable MAX_PATH in the Windows API. In Windows itself however, a path plus filename can be much longer. Try it and see.
The given SGET function returns up to 255 characters starting immediately after the last backslash. The second parameter of the SGET function is the number of characters to "get". Since the file name cannot be more than 255 characters, the entire file name will always be extracted by this function. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kramer, Jason J Sent: December-16-15 12:56 PM To: Stephen Markson Subject: [RBASE-L] - RE: extract file name from a full path Using 255 characters as the cut-off can have some unintended consequences. Windows file paths (not names) max out at 260 characters (and the example given was a full path including drive letter, not just a name). See the Maximum Path Length Limitations section of https://msdn.microsoft.com/en-us/library/windows/desktop/aa365247%28v=vs.85%29.aspx for full details. If you use 255 instead of 260 for the second parameter of SGET, and you have a 255 character file name, then you will cut off the end of the file name because the 255th character will not be the last character in the string. The drive letter, colon, and backslash all count as characters and will be part of the path. As an added wrinkle, if your source of the file path is a Unicode Windows API function, then you could conceivable receive a path of up to 32767 characters (same section of the MSDN page linked above). Admittedly, this is unlikely, but possible in all modern versions of Windows. To fully account for that, you could rewrite Stephen's function as: SET V vFileName=(SGET(.x,(SLEN(.x)),SLOCP(.x, '\',-1)+1)). Thanks, Jason Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Wednesday, December 16, 2015 12:22 PM To: Kramer, Jason J <[email protected]> Subject: [RBASE-L] - RE: extract file name from a full path That's ART! Bruce --- Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile On 2015-12-16 08:08, Stephen Markson wrote: > Hello, > > Simplest way to do this? > > If x is the var with full path and filename: > > SET V vFileName=(SGET(.x,255,SLOCP(.x, '\',-1)+1)) > > Windows file names can't be more than 255 characters and R:Base will > automatically remove any trailing spaces. > > > Regards, > > Stephen Markson > The Pharmacy Examining Board of Canada > 416.979.2431 x251 > > From: [email protected] [mailto:[email protected]] On Behalf Of > Kramer, Jason J > Sent: December-14-15 1:33 PM > To: Stephen Markson > Subject: [RBASE-L] - RE: extract file name from a full path > > Dear Daniele, > Assuming you are using a comma (,) as your delimiter > and don't want to change it, then this code will get you the filename: > > SET VAR voripath TEXT = > 'C:\RIARDO_95\RIFIUTI_CLIENT\ARCHIVIO_PDF\150101-rifiuto assolutamente > non pericoloso.pdf' > SET VAR vnewpath TEXT = (SRPL((SRPL(.voripath,',','?',0)),'\',',',0)) > -- Replace all the commas with question marks because commas are valid > file name character and question marks are not. If you leave commas > in the path, and you are using commas as your delimiter your substring > count will be thrown off. > -- Replace the back slashes with commas. > SET VAR vsubcount INTEGER = (ITEMCNT(.vnewpath)) > -- Count the number of substring. > SET VAR vfilename TEXT = > (SRPL((SSUB(.vnewpath,.vsubcount)),'?',',',0)) > -- Return the last substring (which will always be the filename) after > converting any questions marks back to commas. > -- Please note that this returns the full file name, including the > extension. If you don't want the extension, you will have to strip > that out, but that is far more complex because a filename can contain > multiple periods and extensions do not have to be only three or four > characters. > > Thanks, > > Jason > > Jason Kramer > University Archives and Records Management > 002 Pearson Hall > (302) 831 - 3127 (voice) > (302) 831 - 6903 (fax) > > From: [email protected] [mailto:[email protected]] On Behalf Of > Daniele Barbieri > Sent: Monday, December 14, 2015 1:09 PM > To: Kramer, Jason J <[email protected]> > Subject: [RBASE-L] - extract file name from a full path > > Hello > how can I extract the file name from a full path ? > for example in the full path > C:\RIARDO_95\RIFIUTI_CLIENT\ARCHIVIO_PDF\150101-rifiuto assolutamente > non pericoloso.pdf I need to extract the file name 150101-rifiuto > assolutamente non pericoloso.pdf > > TIA > > Daniele Barbieri > B.M.B. Informatica > > ________________________________ > [Image removed by sender. Avast logo]<https://www.avast.com/antivirus> > > > Questa e-mail รจ stata controllata per individuare virus con Avast > antivirus. > www.avast.com<https://www.avast.com/antivirus>
