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!
Solved! Go to Solution.
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
If it's at the beginning of your lines, you could do something like this
REGEX_Replace([Field], "^[^A-Z0-9]*", "")
Cheers,