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?
Solved
Recognize "strikethrough" in cells
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.
- Best Answer
Since the strikethrough is just a visual effect (like underline and italics), I don't believe that's currently possible using FME.
- Contributor
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.
+35- Influencer
@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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.