I have this data that I want to be treated as immutable (read as strings) in the format CSV (but i suspect that this issue is true for other formats as well?) but FME keeps auto format it to a different format. I think this started with FME 2024 or possibly 2023. Since then I’ve somewhat changed methodology for new work spaces, but yesterday a revisited an old WS and got reminded of this source of frustration. I hope that someone can cure this case of “excel-autoformat-hell” with a solution or an explanation? I really don’t want my data changed automatically in any shape or form.
Example.
CSV-file states that attribute “Datum” has the value ‘2026-05-20’ FME (CSV) reader keeps format it to ‘20260520’. Even if i manually change the attribute to data type string or varchar FME still formats the date according to above.
