+6Hi,
I am facing a problem while writing into a csv.file:
FME converts the string '2-4' into 02.Apr., no matter what field type is set.
E.g. '17-19' remains as it is since it cannot be changed to a date Format.
Is there any smart Workaround or do I have to avoid/replace these strings?
Best answer by jeroenstiers
Hi femo,
In what software are you checking the result? Is that in FME Inspector / Excel / Notepad(++)
Because Excel is known to change the format indeed but when checking the data in Notepad++, does this conversion still happens?
+7Hi femo,
In what software are you checking the result? Is that in FME Inspector / Excel / Notepad(++)
Because Excel is known to change the format indeed but when checking the data in Notepad++, does this conversion still happens?
I agree with @jeroenstiers, it's most probably a presentation issue. Excel is a prime suspect for this as it often tries to guess the format of cell contents. If it is indeed Excel, try formatting the cells as "Text" and see if that works.
If nothing else works, try opening the CSV in something like Notepad and verify the contents.
