+1
Hi FME community,
I am still fairly new to FME. I'm getting stuck with date/time fields in csvs and excel documents. I've attached the field I'm trying to convert into DD/MM/YYYY HH:MM (%d/%m/%Y %h:%m ?), but it writes out empty if I try the DateConverter or AttributeManager> Text editor > DateTimeFormat. It's likely I'm using the transformers incorrectly. Is anyone able to point me in the right direction?
Best answer by j.botterill
View original
+19
Hi epro,
Firstly ensuring the CSV reader separates
the columns, confirming the delimiter type in the parameter's
So 15/08/2022 10:59:52 a.m. appears to be a custom "Input" format. Expanding the quick reference and using the Preview to see if we have the correct syntax and
soon find that perhaps the a.m. and p.m. needs a stringreplacer before the Dateconverter?
another string replacer for the pm...
run to the last string replacer and inspect the new date field values
Input format
%d/%m/%Y %H:%M:%S %p
15/08/2022 10:59:52 am
+2
@epro_admin Thanks for including a small sample dataset - that makes it much easier to test a solution.
Just for completeness... The CSV reader has the capability to parse data/time fields, it's buried in the reader parameters:
But... in this case it won't help since there is no way around the 'a.m.' or 'p.m.' format, so you have to use the approach described by @jamesb16otterill
+1
Thank you both for your replies!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
