Question

How can i read csv file daily?

  • 14 September 2018
  • 3 replies
  • 0 views
K

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.

3 replies

david_r
Rank
Userlevel 4

Try using a DateTimeStamper to create the filename using today's date, then send it to a FeatureReader configured for your CSV.

D

How would you reformat this if the date needs to be in MMDDYYYY format?

chrisatsafe
Rank
Badge +2

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%Y

Or 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:

0684Q00000ArMBsQAN.png

Hope that helps.

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.