Thank you. all the methods suggested by this list work well. thank you again Daniele
-----Messaggio originale----- From: A. Razzak Memon Sent: Tuesday, December 15, 2015 1:36 AM To: [email protected] Subject: [RBASE-L] - Re: extract file name from a full path At 01:08 PM 12/14/2015, Daniele Barbieri wrote:
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
Daniele, Here is a swift code to extract the file name using the R:BASE SLEN, SLOCP, and SGET functions. Simply copy and paste the code below, and then run the file. Watch the presentation! -- Start here ... -- ExtractingFileName.RMD -- Author: A. Razzak Memon -- Date Created: December 14, 2015 -- Last Updated: -- Pre-define all variables SET VAR vFileWithFullPath TEXT = NULL SET VAR vLength INTEGER = 0 SET VAR vLastSlash INTEGER = 0 SET VAR vFileName TEXT = NULL SET VAR vFileWithFullPath = + 'C:\RIARDO_95\RIFIUTI_CLIENT\ARCHIVIO_PDF\150101-rifiuto assolutamente non pericoloso.pdf' -- Find the exact length SET VAR vLength = (SLEN(.vFileWithFullPath)) -- Find the last slash SET VARIABLE vLastSlash = (SLOCP(.vFileWithFullPath,'\',-1)) -- Now get the exact file name SET VAR vFileName = (SGET(.vFileWithFullPath,(.vLength-.vLastSlash),(.vLastSlash+1))) CLS PAUSE 2 USING .vFileName CAPTION 'Extracting File Name' ICON WINDOWS + BUTTON 'Press any key to continue ...' + OPTION BACK_COLOR WHITE + |MESSAGE_FONT_NAME Tahoma + |MESSAGE_FONT_COLOR NAVY + |MESSAGE_FONT_SIZE 12 CLEAR VARIABLES vFileWithFullPath,vLength,vLastSlash RETURN -- end here That's all there is to it! Very Best R:egards, Razzak. --- Questa e-mail รจ stata controllata per individuare virus con Avast antivirus. https://www.avast.com/antivirus

