How to Remove Strikethrough Content in Alteryx

[tamluenwai29]

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. 

 

[ShankerV]

Hi @tamluenwai29 

Please refer to the below post which will help to solve your problem, 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Knowledge-Sharing-Read-Excel-D...

Many thanks

Shanker V

[tamluenwai29]

Hi Shanker, 

I have go through the post already. However it seems that it is not suitable in my case. 

i.e., all content stored separately in every single cell. However, in my case all content stored in one cell,

[Raj]

@tamluenwai29 share some sample data.

[apathetichell]

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...

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

[tamluenwai29]

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-i... in here, and attached my workflow and sample excel file. 

Thanks a lot!