Unable to trim special character

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!

Datasets

Accepted answers

binu_acs

@Jake5 another option to exclude non-ascii characters with the help of the Regex_replace function

REGEX_Replace([Field1], "[^ -~]", '$1')

Non_Ascii_18_05.yxmd

All comments

DataNath

Does sticking it in a replace formula like this do the trick? Have just used another special character to test.

binu_acs

@Jake5 another option to exclude non-ascii characters with the help of the Regex_replace function

REGEX_Replace([Field1], "[^ -~]", '$1')

Non_Ascii_18_05.yxmd

dYoast

Assuming the arrow is only one character, you might be able to use this formula: Right([Firm Name], Length([Firm Name])-1)

Jake5

This solution worked. Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703