Good morning. I seem to be having a little difficulty converting a string into a timestamp. I'm good in all of the places I need to do this conversion but 1. The date I'm being fed is of the form 20-MAY-18. I connected this to a scan from string with the %d-%s-%d, but the %s is coming back as MAY-18 and the last number is coming up as 0. I thought maybe it had something to do with my delimiters, so I changed them to / instead of -, but it's still giving me MAY/18. Any one have any suggestions on how to get this to cooperate??? Am I doing something wrong???

Actually Bob, if you replace the format string with %<%d-%B-%y>T then the required format "20-May-18" is converted perfectly !! Nice one.

Once I figured out how to use Scan from String, I use it for all of my "Scan from String" problems. You have a string, "20 May 2018", and you want to convert it to a TimeStamp. Drop down a Scan from String, wire "20 MAY 2018" into the String Input, and wire a TimeStamp constant into the Default Value 1 slot. Be sure to wire Error Out to allow the function to warn you when you try to convert "20 Mabel 2018" ... Now the only thing missing is the Format String, which (by default) is "%T", i.e. the generic Absolute Time format. But you have a specific Time format -- a "day of month" (%d) separated by a space from a "Full Month Name" (%B), though this might also be an "Abbreviated Month Name" (%b), again separated by a space from a 4-digit year (%Y). This expanded Format String is written %<%d %B %Y>T and is shown in this Snippet: If there is more before or after this String, just add appropriate default Input types and expand the Format String to match. If the TimeStamp also includes Time, the appropriate format specifications for them can be placed inside the Format String illustrated above. To see the (bewildering) list of TimeStamp Formats, search Help for "Format Codes for the Time Format String". Bob Schor

The "%s" format specifier will match any non-whitespace characters, including a dash or slash, and only stops when it reaches a whitespace character. If you want to limit it to only matching capital letters, you can use "%[A-Z]", then it will stop when it reaches the dash or slash.

LabVIEW

Scan from String Issue

Solved!

Author

wow, that is a lot cleaner! Thanks!

(didn't even think of telling it is a date/time... doh!)

Message 11 of 11

(491 Views)

LabVIEW

Scan from String Issue

Re: Scan from String Issue