Skip to main content
Solved

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


fdw
Contributor
Forum|alt.badge.img+6
  • Contributor

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

View original
Did this help you find an answer to your question?

4 replies

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

Hi @fdw​ ,

 

can you please provide a sample data?


fdw
Contributor
Forum|alt.badge.img+6
  • 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+43
  • Safer
  • August 21, 2020
fdw wrote:

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+43
  • Safer
  • August 21, 2020
mark2atsafe wrote:

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

Filed as FMEDESKTOP-10638


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