Skip to main content
Question

Why is the CSV reader truncating my string value but displaying the correct one?


It looks like it displays the correct value but for some reason when you click on it or look in the "Feature Information" it looks like it's the truncated version of my string. When I try to preform other operations it'll use that truncated version too which sucks.

imageimage

4 replies

evieatsafe
Safer
  • Safer
  • January 5, 2024

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


  • Author
  • January 5, 2024

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!


evieatsafe
Safer
  • Safer
  • January 5, 2024

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.


  • Author
  • January 5, 2024

Thank you for trying @Evie Lapalme​ !


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings