Skip to main content
Solved

Feature reader (CSV) can't handle arithmethic expression and fails

  • August 20, 2020
  • 4 replies
  • 38 views

fdw
Contributor
Forum|alt.badge.img+7

Hi,

 

I'm using a feature reader to read a bunch of CSV's with changing column and data row numbers. I first extract the row numbers with a text file reader en feed these values into a feature reader. Like so:

 

feature reader setup

When running the workspace it looks like FME interprets my expression as a text:

feature reader error

Using FME 2020.1 here. Does anyone know what is wrong? The feature reader only allows for arithmetic expressions so no option to enter text in the "Data Start Line" field

 

Freek

Best answer by fdw

It works when you change the formula to @Evaluate(@Value(text_line_number)+3) but I expected FME to do that for me since I used an Arithmetic Editor.

 

Perhaps a small bug

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

davtorgh
Contributor
Forum|alt.badge.img+12
  • Contributor
  • August 20, 2020

Hi @fdw​ ,

 

can you please provide a sample data?


fdw
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • Best Answer
  • August 21, 2020

It works when you change the formula to @Evaluate(@Value(text_line_number)+3) but I expected FME to do that for me since I used an Arithmetic Editor.

 

Perhaps a small bug


mark2atsafe
Safer
Forum|alt.badge.img+59
  • Safer
  • August 21, 2020

It works when you change the formula to @Evaluate(@Value(text_line_number)+3) but I expected FME to do that for me since I used an Arithmetic Editor.

 

Perhaps a small bug

Sounds like it. I'll check it out and file an issue with our developers.


mark2atsafe
Safer
Forum|alt.badge.img+59
  • Safer
  • August 21, 2020

Sounds like it. I'll check it out and file an issue with our developers.

Filed as FMEDESKTOP-10638