Hi @sazhou​ I think we need a bit more information before being able to answer.

• What version and build number of FME are you using?
• Are you able to share a sample of your CSV?
• What's an example of other operations you are using later in the translation?
• Have you tried round tripping your data to see if this is being truncated? (write it back out to CSV without any transformations)

Happy to help,

Evie

Hi @Evie Lapalme​ I'm using FME Workbench 2023.0.0.1 and I just attached an example file to the question. Pretty much any transformer I use is treating the value as "33" not "3331'35.0"N 11709'54.3"W" like it should be.

I've tried round tripping and the outputted CSV file ends up just be 33. It looks like the truncation occurs right when it's read in. I've open the file in Excel and there doesn't seem to be anything wrong with it, it displays "3331'35.0"N 11709'54.3"W" as expected.

Thank you for your tips!

Hi @sazhou​ thanks for the additional information! I could not reproduce the truncation in your version or any version of 2023.x. I'm wondering if you could add a new CSV reader to your workspace to see if you get the same result. Otherwise, I would suggest submitting a support case with us for someone to investigate further. Sorry to not be of more help at this time.

Thank you for trying @Evie Lapalme​ !