Unknown Special Character

Trying to find and replace the symbol (have to paste a photo of it because iusing RegEx on a fixed delimited file that I am working through with a client. The symbol referenced is at the beginning of some lines within the report they are using and I can't seem to find the coding for it anywhere. Thanks for any help!

Regex

Parse

Data Investigation

Accepted answers

Hi

use notepad ++ and open the file

and use this option.

may help resolve to identify which ascii of control is

[]

All comments

Hi

use notepad ++ and open the file

and use this option.

may help resolve to identify which ascii of control is

[]

Thanks Geraldo. It came back with FF - Form Feed so I was able to pop in \f to the RegEx and she's a beaut.

Cheers,

Michael

Hi @michaeljones1

If it's at the beginning of your lines, you could do something like this

REGEX_Replace([Field], "^[^A-Z0-9]*", "")

Cheers,

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703