Hello, I am a new FME user. im gonna store csv file in one folder daily. (ex. 20180914.csv)
If it comes in daily, is there a way to read only today's csv file?
Thanks in advanced.
Question
How can i read csv file daily?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Try using a DateTimeStamper to create the filename using today's date, then send it to a FeatureReader configured for your CSV.
+2- Contributor
How would you reformat this if the date needs to be in MMDDYYYY format?
Hi @datacrypt,
If you would like to reformat the date to MMDDYYYY, you could place a DateTimeConverter after the DateTimeStamper. Then, in the DateTimeConverter parameters, set the Output Format to:
%m%d%YOr in the format you prefer. We have an awesome doc that covers the Format String Flags and Examples that can help you figure out which flag to use in order to get your expected output.
Another helpful thing inside the DateTimeConverter is the Preview Data section as it will show you an example of what the output will look like:
Hope that helps.