This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The original dataset I'm sourcing is from Hadoop, so I unfortunately can't manually clean this up. But the string comes in something like this "NameExample".
I think it is some tab error that is triggering this rectangular type character. Any tips on how to clean this? I tried the Data Cleanse tool and it didn't work. Maybe a find and replace with Text Input?
I wasn't able to get that character into the workflow to test ways to cleanse it out. My first idea was to try a RegEx formula that replaces any character that isn't alphanumeric. If the input field to be cleansed is called "Target", then the expression in a Formula tool would be: