Thanks Mark and Hans. Mark, your solution that was used at the FME Idol contest adapted well and thanks for the example, especially the part about breaking the list components into new variables. That will really come in handy later. Thanks again, st
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mark2atsafe Sent: July 31, 2007 7:19 PM To: [email protected] Subject: [fme] Re: Text File to GeoDatabase (MDB) 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 <http://www.fmepedia.com/index.php/FME_Idol_Challenge_1_Results> ...(although it uses AttributeSplitter instead of SubstringExtractor) Mark --- In [email protected] <mailto:fme%40yahoogroups.com> , "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:fme%40yahoogroups.com> [mailto:[email protected] <mailto:fme%40yahoogroups.com> ] On Behalf Of Hans > van der Maarel > Sent: July 31, 2007 1:25 PM > To: [email protected] <mailto:fme%40yahoogroups.com> > 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 >
