Hi Dj Sures...
I've been playing around with the split function for the last couple of days writing an automated announcement routine that simply reads from a long list of dates with attached comments so that my bot can remind me of birthdays, etc.
While doing so I noticed an interesting behaviour with the SPLIT() function.
It seems that when I import a preformatted date from my comma delimited txt file it comes in as a txt data but it is treated as a math formula when split.
Ie
I have written to a txt file a date and a comment to be spoken when imported from the txt file and assigned it is read as simple text I have:
$Announce_Date,Announcement
"21/01/2013,Hello DJ Sures"
but when I Split($TXT,",",1)
the date information is calculated as 25 divided by 12 divided by 2013
eg. "0.000866336633663366"
Is this intentional?
I would have thought that I would have to do post processing on my text data rather than the EZ-Script so a date coming in as txt remains as txt until I assign it to be a date!
My work around was to write the date as three integers:
$Announce_day,$Announce_month,$Announce_year,$Announcement
21,1,2013,Hello DJ Sures
Works fine!
What are your thoughts.....?
Asked
— Edited
Put the date as a string by surrounding it in "quotes" and you'll be fine