Question about dates and arrays

[Mellon]

I suspect this is something I'll have to work around but I figured I would ask.

I have a text string in a file that read like this:

11485 Relocate Matanzas River Buoy 80A R N "80A" N 29 43' 18.788" W 081 14' 46.663" 29.72189 -81.24629 LNM 29/10, 7th Dist 279 11485_1 7/27/2010

$LNMitems = StringSplit($lnmline, @TAB)
    $theChartnumber = $LNMitems[1]
    $theActionprocess =$LNMitems[2]
    $LNMIssueDate=$LNMitems[10]

$LNMitem[10] is the date at the end of the string. However, when I process that line it does not return as a date but rather as a number. Is there anyway to make it retain the date format as a text string. I only have to list it since a change to the buoy can happen at different dates. There is no need to process anything based on the date.

[Melba23]

Mellon,

Look at _DayValueToDate - it might be what you need.

M23

[Mellon]

I'll give it a shot but I don't think it will work. $LNMitem[10] returns a value of 280 when I run it against that line. July 2010 does not seem to be only 280 days from noon 4713 BC January 1 .

[Mellon]

It didn't work. I just worked around it by use the LNM number. (LNM 29/10 in this case)

[Bowmore]

Are you sure that the lines are being split into fields correctly.

It may be worth trying this just to confirm that $LNMitems[10] is the date field.

#include <array.au3>

$LNMitems = StringSplit($lnmline, @TAB)

_ArrayDisplay($LNMitems)

[BrewManNH]

Where are the Tabs in the line, and how many are there? Unless there's 9 Tab characters in total in that line of text, the 10th item may or may not be the date at the end.

Also, is the date at the end of the line every time? If so you could use $SomeVariable = StringRight($lnmline, 10) and then use StringStripWS($SomeVariable, 1) to strip off any spaces that might be there if the month is < 10.

[kylomas]

mellon,

Put in an _arraydisplay as Bowmore suggests. The display will show you what values are at each offset (element) of the array.

kylomas

[Mellon]

A) Thanks, I didn't know that tool existed. That is extremely handy.

You were right. The date would be found in LNMitem[12], not [10] When I was counting the tabs across I screwed up by two. (And assumed something I shouldn't. When this was comma delimited it was in space 10.)

Thanks for the help. This is a text file from NOAA that contains chart corrections that are needed to update charts. For reasons known only to them they charge the format of the list about every three months. Keeps me learning about Autoit at least.

Thanks again.