Jump to content

Extract charachters from filename


Recommended Posts

How can I extract characters from a file name? I know how to use the stringtrimright and left but i need to get specific parts of the file name into different variables. The filename is in the following format APBR20091130a.LST . I need the first two as a variable which i can do with stringtrimleft but how do i get the 2009 as a variable 09, the month as a variable and the day asa variable and drop the rest?

Link to comment
Share on other sites

  • Moderators

TuMiM,

If all the file names have exactly the same format (MMMMYYYYTTTTa.ext) then you can do it like this: :mellow:

$sFileName = "APBR20091130a.LST"

$sMonth = StringMid($sFileName, 1, 4)
$sYear = StringMid($sFileName, 7, 2)
$sTime = StringMid($sFileName, 9, 4)

MsgBox(0, "Extracted", $sMonth & @CRLF & $sYear & @CRLF & $sTime)

If you have variable sized elements, we need to rethink. :P

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...