Unknown Special Character

[michaeljones1]

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!

[geraldo · Accepted solution]

Hi

use notepad ++ and open the file

and use this option.

may help resolve to identify which ascii of control is

[]

[michaeljones1]

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

[Thableaus]

Hi @michaeljones1 

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

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

Cheers,