Skip to main content
  • EN

I am complete novice to FME.

I have a .txt file which I wish to convert to excel. But I only want some of the information to be brought into the excel spreadsheet. I'm not sure how to begin.

All I want in the excel spreadsheet (bottom image) is the name e.g HP40 but without the .tif extension and the date e.g 04/03/2016 without the time.

I am not sure what connectors to use or how to strip out the unwanted info from the .txt file.

You can read in the text file as a CSV or CAT depending on whether the columns are separated by tabs/spaces or are a specific width.

 

 

The FilenamePartExtractor will give you the root filename, and the DateTimeFormatter can give you the date, though it may be simpler to just use an attribute splitter.

@mitburger SubstrngExtractor will let you extract the file name. Or StringSearcher if you're comfortable with regular expressions

Reply


Community Stats

30,364
Posts
115,373
Replies
38,148
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.