This content has been marked as final. Show 2 replies
I messed around with a RegEx and came up with this:
It seems to work but I'm no unicode or regex expert. If someone who knows their stuff with RegEx and Unicode could review my RegEx and tell me if it's truly only removing NULLs that would be great.
Well, it's a relatively simple regex , so there isn't much to verifying it. You've got the right expression for hex code 0. I'm not sure you need the brackets at this point (indicating a character class), but it's easier to start with them so that you don't need to remember them once you find other characters to exclude.
As near as I can tell, it should be what you want. You may end up wanting a more complicated regex if you find other invalid characters you want to remove (like byte order marks), but that could be done in a separate statement.