Removing Ellipse Symbol (...) from String columns in Alteryx

[Tej_Singh]

Hi All,

Can we remove ellipse symbol (...) from the string columns? I am unable to do so using Replace function as 3 dots are not replacing ellipse symbol. Any thoughts how to achieve this? Attaching data for reference.

[DataNath]

Hey @Tej_Singh - I've seen this before and I believe once you type the 3 dots it becomes it's own 'ellipses' character. Therefore, to do this in the past I've just copied and pasted the actual character itself (from Excel) into the replace target: