How to Remove Strikethrough Content in Alteryx

Question

Hi All,

I got an Excel file, and I am going to phrase a column named by: Content. However, the data under this column contains strikethrough data like the following photo that I attached down below:

I would like to know how to remove all content with strikethroug in Alteryx? Here's my expected output

Thanks All.

tamluenwai29 · Answer

Hi mate,

sorry for getting you late.

I have posted a new post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Remove-Strikethrough-Content-in-Alteryx/td-p/1311484 in here, and attached my workflow and sample excel file.

Thanks a lot!

apathetichell · Answer

You will need to open your excel file as a zip - extract the underlying the xml - figure out which files and which xml relate to the strikethrough - remap back that back to your data. Have I done it - no? Would I do it? I mean if I was paid an absurd amount - maybe? Is it possible? probably.  Let me be clear - doing what you are asking sucks. It is not fun, it is not easy and I cannot see situation where it is wothwhile.

You can try playing with this - https://stackoverflow.com/questions/40000239/import-excel-file-in-python-and-identify-cells-of-which-the-content-is-strikethr

my hunch is that if you have never opened an Excel file before and looked at the .xml this may be outside your expertise.

Raj · Answer

@tamluenwai29 share some sample data.