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/
