Aceguy Posted May 18, 2009 Share Posted May 18, 2009 (edited) #include <Excel.au3> #include <file.au3> #include<array.au3> $file=@MyDocumentsDir&"\My New Book 1.xlsx" $reg=StringRegExp($file,"(?<=\\).*(?=\.)",3) if IsArray($reg) then _ArrayDisplay($reg) anyone know why this isnt capturing the "My New Book 1" Many thanks in advance. Edited May 18, 2009 by Aceguy [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
picaxe Posted May 18, 2009 Share Posted May 18, 2009 Another way$file=@MyDocumentsDir&"\My New Book 1.xlsx" ConsoleWrite(StringRegExpReplace(StringRegExpReplace($file, '([\\ \w:]*)\\', ''), '\..*', '') & @LF) Link to comment Share on other sites More sharing options...
Aceguy Posted May 18, 2009 Author Share Posted May 18, 2009 thanks for quick response, but it doenst return it correctly.......the $file will be this (full path)C:\Users\Ace - PC\Documents\My New Book 1.xlsxit returnsAce -My New Book 1 [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
weaponx Posted May 18, 2009 Share Posted May 18, 2009 Topic title = Useless Topic description = Meaningless Link to comment Share on other sites More sharing options...
picaxe Posted May 18, 2009 Share Posted May 18, 2009 $file=@MyDocumentsDir&"\My New Book 1.xlsx" ConsoleWrite(StringRegExpReplace($file, '([\\ \w:]*)\\', '') & @LF) Link to comment Share on other sites More sharing options...
MrCreatoR Posted May 18, 2009 Share Posted May 18, 2009 $file = @MyDocumentsDir & "\My New Book 1.xlsx" ConsoleWrite(StringRegExpReplace($file, '^.*\\|\.[^.]*$', '\1') & @LF) Spoiler Using OS: Win 7 Professional, Using AutoIt Ver(s): 3.3.6.1 / 3.3.8.1 AutoIt Russian Community My Work... Spoiler Projects: ATT - Application Translate Tool {new}| BlockIt - Block files & folders {new}| SIP - Selected Image Preview {new}| SISCABMAN - SciTE Abbreviations Manager {new}| AutoIt Path Switcher | AutoIt Menu for Opera! | YouTube Download Center! | Desktop Icons Restorator | Math Tasks | KeyBoard & Mouse Cleaner | CaptureIt - Capture Images Utility | CheckFileSize ProgramUDFs: OnAutoItErrorRegister - Handle AutoIt critical errors {new}| AutoIt Syntax Highlight {new}| Opera Library! | Winamp Library | GetFolderToMenu | Custom_InputBox()! | _FileRun UDF | _CheckInput() UDF | _GUIInputSetOnlyNumbers() UDF | _FileGetValidName() UDF | _GUICtrlCreateRadioCBox UDF | _GuiCreateGrid() | _PathSplitByRegExp() | _GUICtrlListView_MoveItems - UDF | GUICtrlSetOnHover_UDF! | _ControlTab UDF! | _MouseSetOnEvent() UDF! | _ProcessListEx - UDF | GUICtrl_SetResizing - UDF! | Mod. for _IniString UDFs | _StringStripChars UDF | _ColorIsDarkShade UDF | _ColorConvertValue UDF | _GUICtrlTab_CoverBackground | CUI_App_UDF | _IncludeScripts UDF | _AutoIt3ExecuteCode | _DragList UDF | Mod. for _ListView_Progress | _ListView_SysLink | _GenerateRandomNumbers | _BlockInputEx | _IsPressedEx | OnAutoItExit Handler | _GUICtrlCreateTFLabel UDF | WinControlSetEvent UDF | Mod. for _DirGetSizeEx UDF Examples: ScreenSaver Demo - Matrix included | Gui Drag Without pause the script | _WinAttach()! | Turn Off/On Monitor | ComboBox Handler Example | Mod. for "Thinking Box" | Cool "About" Box | TasksBar Imitation Demo Like the Projects/UDFs/Examples? Please rate the topic (up-right corner of the post header: Rating ) * === My topics === * ================================================== ================================================== AutoIt is simple, subtle, elegant. © AutoIt Team Link to comment Share on other sites More sharing options...
Aceguy Posted May 18, 2009 Author Share Posted May 18, 2009 (edited) thanks guys... solved @weaponx yourhelp=none Edited May 18, 2009 by Aceguy [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
weaponx Posted May 18, 2009 Share Posted May 18, 2009 thanks guys... solved@weaponx yourhelp=noneYea your topic will be really helpful when someone searches titles for "StringRegExp" ... Link to comment Share on other sites More sharing options...
MrCreatoR Posted May 18, 2009 Share Posted May 18, 2009 thanks guys... solved@weaponx yourhelp=noneHe helping a lot on this forum, you should understand it at least from his status... and you really didn't gave as complete information, some of as had to enable our magic skills of “mind reading” to understand the problem So please, next time (and even now you can edit your post) be more specific, don't leave to the others the work you should do yourself, next time others just might not help you only because of this (lack of info). Spoiler Using OS: Win 7 Professional, Using AutoIt Ver(s): 3.3.6.1 / 3.3.8.1 AutoIt Russian Community My Work... Spoiler Projects: ATT - Application Translate Tool {new}| BlockIt - Block files & folders {new}| SIP - Selected Image Preview {new}| SISCABMAN - SciTE Abbreviations Manager {new}| AutoIt Path Switcher | AutoIt Menu for Opera! | YouTube Download Center! | Desktop Icons Restorator | Math Tasks | KeyBoard & Mouse Cleaner | CaptureIt - Capture Images Utility | CheckFileSize ProgramUDFs: OnAutoItErrorRegister - Handle AutoIt critical errors {new}| AutoIt Syntax Highlight {new}| Opera Library! | Winamp Library | GetFolderToMenu | Custom_InputBox()! | _FileRun UDF | _CheckInput() UDF | _GUIInputSetOnlyNumbers() UDF | _FileGetValidName() UDF | _GUICtrlCreateRadioCBox UDF | _GuiCreateGrid() | _PathSplitByRegExp() | _GUICtrlListView_MoveItems - UDF | GUICtrlSetOnHover_UDF! | _ControlTab UDF! | _MouseSetOnEvent() UDF! | _ProcessListEx - UDF | GUICtrl_SetResizing - UDF! | Mod. for _IniString UDFs | _StringStripChars UDF | _ColorIsDarkShade UDF | _ColorConvertValue UDF | _GUICtrlTab_CoverBackground | CUI_App_UDF | _IncludeScripts UDF | _AutoIt3ExecuteCode | _DragList UDF | Mod. for _ListView_Progress | _ListView_SysLink | _GenerateRandomNumbers | _BlockInputEx | _IsPressedEx | OnAutoItExit Handler | _GUICtrlCreateTFLabel UDF | WinControlSetEvent UDF | Mod. for _DirGetSizeEx UDF Examples: ScreenSaver Demo - Matrix included | Gui Drag Without pause the script | _WinAttach()! | Turn Off/On Monitor | ComboBox Handler Example | Mod. for "Thinking Box" | Cool "About" Box | TasksBar Imitation Demo Like the Projects/UDFs/Examples? Please rate the topic (up-right corner of the post header: Rating ) * === My topics === * ================================================== ================================================== AutoIt is simple, subtle, elegant. © AutoIt Team Link to comment Share on other sites More sharing options...
Aceguy Posted May 18, 2009 Author Share Posted May 18, 2009 (edited) fair one.. My Apologies weaponx. Edited May 18, 2009 by Aceguy [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now