Jump to content

_GetDateInString() - find date/time in a string using a date format notation (DD Mon YYYY hh:mm)


Recommended Posts

I am currently working on a project in which I have to find timestamps in multiple formated patterns.

The idea is to search time stamps in log files.

If successful _GetDateInString() will returns a timestamp in YYYY/MM/DD hh:mm:ss


_GetDateInString("...Process Last Run 17 JUN at 05:15...", "DD Mon at hh:mm")

will return 2014/06/17 05:15:00

Formats tested:
- DDMonYY hh:mm:ss  (matches dates like 30May14 03:59:59)
- DD Mon YYYY hh:mm   - Mon, DD YYYY hh:mm:ss   - Mon, D YYYY hh:mm:ss   - DD Mon at hh:mm
- DMonYY hh:mm:ss     - DMon hh:mm:ss           - DD/MM/YYYY hh:mm       - DD-MM-YYYY  hh:mm
- DDMMYYYY hh:mm      - DD/MM hh:mm             - MM.DD.YYYY  hh:mm      - YYYYDDMM  hh:mm
- YYYYMMDD - hh:mm    - DD.MM  hh:mm            - D/M/YYYY hh:mm         - D.M.YYYY hh:mm
- M.D.YY h:mm:ss      - M.D.YY hh:mm            - M.D.YY  hh:mm          - M.D.YYYY h:mm:ss
- M.D.YYYY  h:mm:ss   - M.D at  h:mm:ss        

and many other formats...

udf with examples:





CheckUpdate - SelfUpdating script ------- Self updating script

Dynamic input validation ------------------- Use a Input masks can make your life easier and Validation can be as simple

MsgBox with CountDown ------------------- MsgBox with visual countdown

Display Multiline text cells in ListView ---- Example of pop-up or ToolTip for multiline text items in ListView

Presentation Manager ---------------------- Program to display and refresh different Border-less GUI's on a Display (large screen TV)

USB Drive Tools ------------------------------ Tool to help you with your USB drive management

Input Period udf ------------------------------ GUI for a period input

Excel ColorPicker ---------------------------- Color pickup tool will allow you to select a color from the standard Excel color palette

Excel Chart UDF ----------------------------- Collaboration project with water 

GetDateInString ------------------------------ Find date/time in a string using a date format notation like DD Mon YYYY hh:mm

TaskListAllDetailed --------------------------- List All Scheduled Tasks

Computer Info --------------------------------- A collection of information for helpdesk

Shared memory Demo ----------------------- Demo: Two applications communicate with each other through means of a memory share (using Nomad function, 32bit only)

Universal Date Format Conversion -------- Universal date converter from your PC local date format to any format

Disable Windows DetailsPane -------------- Disable Windows Explorer Details Pane

Oracle SQL Report Generator -------------  Oracle Report generator using SQL

SQLite Report Generator -------------------  SQLite Report generator using SQL

SQLite ListView and BLOB demo ---------- Demo: shows how binary (image) objects can be recognized natively in a database BLOB field

DSN-Less Database connection demo --- Demo: ActiveX Data Objects DSN-Less Database access

Animated animals ----------------------------- Fun: Moving animated objects

Perforated image in GUI --------------------- Fun: Perforate your image with image objects

UEZ's Perforator major update ------------- Fun: Pro version of Perforator by UEZ

Visual Crop Tool (GUI) ----------------------- Easy to use Visual Image Crop tool

Visual Image effect (GUI) -------------------- Visually apply effects on an image




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

  • Create New...