Hi Scott, Yes I'd go with the substringExtractor grabbing D, M and S as separate attributes and converting them with the DMSCalculator (or whatever it is called).
The FME Idol contest at last year's User Conference had a very similar task. Check out... http://www.fmepedia.com/index.php/FME_Idol_Challenge_1_Results ...(although it uses AttributeSplitter instead of SubstringExtractor) Mark --- In [email protected], "Tweedy, Scott" <[EMAIL PROTECTED]> wrote: > > Here's a copy of one of the files I'm working with, the lat/long values > are in columns 2 and 3 (no headers): > > > > ________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Hans > van der Maarel > Sent: July 31, 2007 1:25 PM > To: [email protected] > Subject: Re: [fme] Text File to GeoDatabase (MDB) > > > > twee0001 wrote: > > > > > > I'm having a little trouble taking a text file and extracting the > > values I need from it to create a GeoDatabase. > > > > The text file I receive is fixed width text file which lists all the > > attributes and geometry information on each line. The latitude and > > longitude values are in the following format: > > > > ddmmss.xx > > > > I tried reading the file in as a text file and using the > > SUBSTRINGEXTRACTOR to parse out the values I need. My problem arises > > when I try to extract the Lat/Long values and calculate points. The > > first SUBSTRINGEXTRACTOR works, but then it tries to take that single > > value and calcluate the points with it so the rest of the workbench > > fails. > > > > Has anyone tried to extract and create points from a text file like > > this? What's the easiest way to do it? > > Probabely the AttributeSplitter. Could you post a small sample? > > I do assume it's one feature per line, right? Otherwise it may become a > lot more complicated :) > -- > Hans van der Maarel > Red Geographics > > Zevenbergsepoort 44b www.redgeographics.com > 4791 AE Klundert [EMAIL PROTECTED] > <mailto:hans%40redgeographics.com> > The Netherlands phone: +31-168-401035 > 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. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe.com/company/fmeuc2008/index.php for more details. 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/
