Hi Team,
Hope you are well. I need help.
How to get rid of apostrophe in Entire workbook including Column headings. Even i tried few formulas from the community or from the website. Its not going.
Please let me know,
thanks,
@sriniprad08 I am not seeing that issue in my output, i didnt use any tool to remove the extra char
Hi @sriniprad08
Some time the symbol used in Keyboard might be not equal to the symbol available in .csv file.
Hence I have amended the below workflow
Many thanks
Shanker V
Please exclude those columns (i.e untick those numeric columns) in the multi field formula.
@sriniprad08 try the ReplaceChar([location],"'",'') function
This can be achieved with the help of multi field formula tool.
Please use the same formula as yours.
Input was: ' in both header and columns too
Thank you @ShankerV . Unfortunately its not working too. Actually when i download the final output as excel or csv its giving the same '.
@binu_acs Thank you so much. It works inside alteryx. But when i download to excel or csv. The problem remains the same.
@sriniprad08 Can you upload a sample input file to test
please find attached @binu_acs Like this there are many columns
Hi @ShankerV ,
Thank you so much for the kind help. Really appreciate that.
Cheers,
Sri
Hi @binu_acs ,
Thank you so much for the kind help. Really appreciate that,
