Skip!!!!! In my world "text" = "varFileName" from my other XDS script. Dude...freaking right on! I totally appreciate it! So working right now! Basically, I replaced text with varFileName 'cause I turned my screen sideways and I finally picked up what you were putting down!
I clicked on the...
Skip, unfortunately, above is pulling the current system date and time. It's not taking the value, parsing, and reformatting. Any other ideas?
String: 20170716134008
I tried....
Function GetDOS(theDate)
theDate = Field (text,"_",4)
theDate = Mid(theDate,5,2) & "/" & Mid(theDate,7,2) & "/" &...
I'm assuming I would use the above and just store then to 2 different variables since they are being indexed into 2 different fields (like excel)?
date = dat
time = Mid(text,9,2) & .........
???
20180716143004 should be 07/16/2018 as 1 value and 14:30:04 as the other value.
So, I actually updated as the below aside from using time cause I got what you meant that I should change the arg.
Function GetDOS(text)
GetDOS = Field (text,"_",4)
End Function
Function ReformatDOS(YMD)
ReformatDOS = Mid(YMD,1,2) & "/" & Mid(YMD,3,2) & "/" & Mid(YMD,5,4)
End Function...
Skip,
Dang it...yeah, not supposed to be that way. So, I need the TOS to be (time). I'll get that changed, duh! But, I believe the key here is that I would need to parse out the relevant digits right? So, from 20180716143004...I need to parse the first 8 digits for the date and then get that...
Driving me crazy! What am I missing?
FileName: Whatever1_Whatever2_Whatever3_20180716143004
Initial Value: 20180716143004
Expected Date Result: 07/16/2018 using varDOS
Expected Time Result: 14:30:04 using varTOS
Here's what I got below. Basically trying to take that long value, and get the...
Wow! Totally Awesome! Makes sense...it's the little stuff! What do you think about the below? Getting the same Expected End. From what I can see, everything is good. Essentially I'm taking a date like 05181984 and making it 05/18/1984.
Function ReformatDOS(YMD)
ReformatDOS = Mid(YMD,1,2) & "/"...
VB Script Error: C:\Users\hrjco\AppData\Local\Adersoft\VbsEdit\Temp\OCDEZEYU.vbs(3, 3) Microsoft VBScript compilation error: Expected 'End'
Purpose of script: I'm essentially trying to see if variable GetDocALIAS = "A587" then the variable GetDOCTYPE will be stored as Doc1, if it's not A587, and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.