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)
This solution worked. Thanks!