Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hello - I have a .txt input where certain records lead with a special character that resembles an upward pointing arrow as shown in the attached screen capture. You'll notice my attempt at trimming out this character but to no avail. Any suggestions on how to remediate? Thanks!
Solved! Go to Solution.
Does sticking it in a replace formula like this do the trick? Have just used another special character to test.
@Jake5 another option to exclude non-ascii characters with the help of the Regex_replace function
REGEX_Replace([Field1], "[^ -~]", '$1')
Assuming the arrow is only one character, you might be able to use this formula: Right([Firm Name], Length([Firm Name])-1)
