Sign in to follow this  
Followers 0
VelvetElvis

Formatting a string

6 posts in this topic

Sorry, but try as I might, regular expressions and the StringFormat function help leave me glassy-eyed.

I need to pad a date string like "2010-6-1" to "2010-06-01" so that month and day always have 2 digits.

Thanks.

Share this post


Link to post
Share on other sites



VelvetElvis,

How are you generating your date string? Does it come as single string or are you creating it from (3) other strings?

If the former, we have to split the string before formatting it - if the latter we do it first. :mellow:

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______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

 

Share this post


Link to post
Share on other sites

VelvetElvis,

How are you generating your date string? Does it come as single string or are you creating it from (3) other strings?

If the former, we have to split the string before formatting it - if the latter we do it first. :mellow:

M23

Hi;

I get the string as "6/1/2010" and I have to convert it to "2010-06-01" (yyyy-mm-dd) so I can use it as part of a filename.

If I can get it into "mm/dd/yyyy" I can use string functions to rearrange it.

However, I'm open to easier answers. :-)

Share this post


Link to post
Share on other sites

$before = "6/1/2010"

MsgBox(64, 'Info', _convertDate($before))

Func _convertDate($d)
    $a = StringSplit($d, '/', 2)
    Return StringFormat('%04s-%02s-%02s', $a[2], $a[0], $a[1])
EndFunc


Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

$before = "6/1/2010"

MsgBox(64, 'Info', _convertDate($before))

Func _convertDate($d)
    $a = StringSplit($d, '/', 2)
    Return StringFormat('%04s-%02s-%02s', $a[2], $a[0], $a[1])
EndFunc

Excellent. Thank you!

Share this post


Link to post
Share on other sites

No Problem. Glad I could help!


Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
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
Sign in to follow this  
Followers 0