Skip to main content
Solved

Recognize "strikethrough" in cells


I am merging an excel spreadsheet and an ArcGIS SDE feature class on a common field. Some of the entries in the spreadsheet have a "Strikethrough" effect--these entries should be ignored, however, FME is matching them anyway. How can I get it to ignore any entries with strikethrough?

Best answer by david_r

Since the strikethrough is just a visual effect (like underline and italics), I don't believe that's currently possible using FME.

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

4 replies

david_r
Celebrity
  • Best Answer
  • October 17, 2017

Since the strikethrough is just a visual effect (like underline and italics), I don't believe that's currently possible using FME.


cws
Contributor
Forum|alt.badge.img
  • Contributor
  • July 24, 2020
david_r wrote:

Since the strikethrough is just a visual effect (like underline and italics), I don't believe that's currently possible using FME.

Has there been any change to this in newer releases of FME. I have a similar issue where I'd like to filter out the strike through values in excel sheets.


ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • July 24, 2020

@cws If you read the excel file with formatting you can identify those cells which have the Strikethrough effect

Tick this box in the reader

You can then test the .formatting attributes for the word STRIKEOUT


cws
Contributor
Forum|alt.badge.img
  • Contributor
  • July 26, 2020

Thanks @ebygomm. Works perfectly.


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