Hi All, Please help me to remove special character as per below snapshot:- in alteryx its showing as "Field Note" ( red notation mark on right top corner of a filed) but when I am copying the data to excel showing as "" special character.(i.e sallysong) I tried to replace it in "find and replace tool" but no luck. please help urgently. thanks in advance
I'm not 100% I get what the issue is, but to try to help out:
1. Try adding a Data Cleansing tool to clean up the field
2. Use the DecomposeUnicodeForMatch([_CurrentField_]) function on the Formula Tool to clean up the field.
Pedro.
Oops, no luck, thanks anyway, i tried to attach the snapshot this time
This red mar- comment or note in excel field, thats i am not able to clean, thinking about find&replace took but not sure what should i place in dind section for this one
@shailendra88 can you provide a fake example that is doing that? It doesn't have to be your dataset, just something that mimics it so we can better understand.
if all you are doing is trying to remove characters other than A-Z, a-z, 0-9; then you can use a RegEx Replace.