Hi Jason, Thank you very much for looking at this for me. Although I didn't use the substringextractor (couldn't figure out how to create a series of 22 -- were you saying I needed to create 22 transformers?), all your other advise helped me get through it when I tried using the attribute splitter. Many thanks!
David --- In [email protected], "Jason Birch" <[EMAIL PROTECTED]> wrote: > > Hi David, > > I think that this will work for you with a bit of effort: > > - Textline reader to read the data > > - Tester for text_line_number > 4 to skip the header information. Only > connect the PASSED output. > > - Series of 22(?) SubstringExtractors to pull the individual columns. > This uses a start index of 0, so subtract 1 from the column numbers in > the specification document as you're building these. > > - CSV output. After connecting this, you can right-click to copy the > attributes from the last transformer, then go into its properties to > remove/reorder them as desired. > > Jason > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > datahungry > Sent: Monday, February 27, 2006 11:17 > To: [email protected] > Subject: [fme] Create CSV from Text file with no comma or tab? > > Hi, > > I'm new here and to FME, so please forgive me if this is redundant. > I've spent quite a bit of time trying to find a transformer capability, > including searching here. Unfortunately I'm not sure what key words or > terms to use for this. > > Anyway, I'm looking for a capability (via transformer?) to help me take > a text file and output to a CSV file format. > > The problem is that the text file I regularly receive (as it gets > updated) has lines treated as records and individual charaters or a > combination of characters that mean very specific things. There are no > comma or tabs or spaces to automatically identify fields. Each field > has a fixed width of characters for each line or record. > > I'll try to post a sample documentation file titled "CD_DOF_README.PDF" > on this group. I'll also try to post a sample text file that it comes > in titled "aal.dat". > > Thanks! > > David > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> 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/
