If that could happen, modify the procedure to do a last check on the
variable looking for the colon immediately following the other SET V
statement.
IF vFileName LIKE '_:%' THEN
SET VAR vFileName = (SGET(.vFileName,(SLEN(.vFileName))-2),3)
ENDIF
On 2015-12-16 1:24 PM, Stephen Markson wrote:
A couple of notes about SET V vFileName=(SGET(.x,255,SLOCP(.x, '\',-1)+1)):
1. It works if the path is omitted;
2. If there is a drive letter and colon and no path, then the drive letter and
colon are included in the returned variable. i.e.
(SGET('C:fred.txt',255,SLOCP('C:fred.txt', '\',-1)+1))=C:fred.txt.
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea
Sent: December-16-15 12:22 PM
To: Stephen Markson
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>
