Editng a string

[azrael811]

I wish to edit the contents of a string so I can use it for comparison. The string is the creation date of a file and its format is "dd/mm/yyyy hh:mm:ss xm" how can I remove the time from the string as the date is the only thing I am interested in ????

 

[FOAD123]

That's a good question.
I'd really like to know how to do a substring in VBscript (if you can)...
I had something similar and I ended up using a loop to search through the string for all instances of ~ as I was using this to break the file up. And then i used to Split function.

I'd suggest you could do the Split function and then just search the array(0) for your date.... Split based on a space (" &quot.
eg DateArray = Split(strDateTime, " ", -1, 1)
This would break it up by dates and the first array element is your date...

 

[tsuji]

Hello azrael811,

sDT = "dd/mm/yyyy hh:mm:ss xm"
sD = Left(sDT,InStr(1,sDT," ",1)-1)
wscript.echo sD

But make sure sDT really is a string as such.

regards - tsuji

 

[FOAD123]

Ahhh so easy!! Why couldn't they just use a function called SubStr or Substring!!

Thanks for your help tsuji....

 

[PHV]

To get the 10 ten chars of a string, just do this:

NewStr=Left(OldStr,10)

Hope This Help
PH.

 

[clarkin]

it is called Mid().

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctmid.asp

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].