Yikes, I'm glad that all of the real history on this coast is in the oral tradition, and unencumbered by the "western" need to apply dates to everything ;) That workspace is at work, and I can't recall exactly. >From memory, I believe that I was having to create a textual date (September >10 1875) from an MSSQL datetime field for presentation purposes. I think that >I was unable to get the DateFormatter to format the old date properly, the >AttributeClassifier failed to recognise it, and the Visualiser was showing >them as, of all things, floats. I ended up doing some funky Grepper stuff to >pattern match the dates and pull out the individual atoms, followed by a >ValueMapper for the month translation, and a Concatenator to merge them back >together. Not too bad (and I love the chance to play with regex) but it took >me a while to figure out what was going on. Jason
________________________________ From: [email protected] on behalf of mark2atsafe Sent: Thu 2006-11-02 2:03 PM To: [email protected] Subject: [fme] Re: Invalid year using DateFormatter What sort of problems are you facing Jason? I'm thinking it's not going to be easy to produce a one-solution-fits-all transformer, given the wide range of formats a date may be. At the moment the DateFormatter only accepts dates of a known structure - there's no mechanism for defining a custom structure, and there's limits on what guesses FME can make. Anyway - I'm not trying to spread alarm and despondency, it does work pretty well. But if there's a specific problem you have then be sure to let us know. BTW - I worked on a project once for property records in Scotland. Some records were so old they were in a different calendar (Julian, not Gregorian) - and that caused more than a few problems! >From wikipedia... "In the British Empire Wednesday 2 September 1752 was followed by Thursday 14 September 1752" - also - "Russia remained on the Julian calendar until after the Russian Revolution (which is thus called the 'October Revolution' but occurred in November according to the Gregorian calendar)" Regards, Mark For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<winmail.dat>>
