[Knowledge Sharing] Read Excel Data without Strikethrough Data

[gawa]

I'd like to share my developed workflow which enables you to read excel data WITHOUT strikethrough data. 

Alteryx standard input tool read data regardless of being strikethrough or not since it is just a kind of font styles such as bold, italic..., while excel creator/reader might want to distinguish them for ease of data process.

All yxmd and yxmc files are archived in the attached .yxzp file.

For example, if you have excel as below.

This workflow will output like this; strikethrough data are totally(or partially) removed. Of course, no-strikethrough data are output as it is. 

Also you can compare data for cells having strikethrough data to see the change between 'before' and 'after'.

You just have to specify the directory which contains target excel files so you can process multiple excel files at once.

Please try it out if you are annoyed with handling strikethrough data.

NOTE: Apologize for any unexpected error and inconvenience it may occur though I checked its functionality as much as possible.

Hope this could help you, thanks!

[ShankerV]

Hi @gawa 

Its a nice one. Much appreciated.

I would also recommend you to upload the macro in the Gallery for everyone's benefit in the future.

Many thanks

Shanker V

[Raj]

@gawa 
thanks for sharing.

[tamluenwai29]

Hi mate, 

I am trying to do the same things. However, I got the following error: 

main_macro_excel_remove_strike_data (61) Record #1: Tool #19: There was an error in regex_search The complexity of matching the regular expression exceeded predefined bounds.  Try refactoring the regular expression to make each choice made by the state machine unambiguous.  This exception is thrown to prevent "eternal" matches that take an indefinite period time to locate.

Do you know which part trigger this error? Thanks a lot!!

I have also create a new post for this problem https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Remove-Strikethrough-Content-i...

My sample excel file and workflow is attached in above post. Could you please give me some advice for this problem?