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.
+22
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.
+2
@mitburger SubstrngExtractor will let you extract the file name. Or StringSearcher if you're comfortable with regular expressions
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
