troubleshooting Question

Need to replace all characters above ASCII with '*' (or similar)

Avatar of Gene Klamerus
Gene KlamerusFlag for United States of America asked on
Regular Expressions* vim* editorsMicrosoft Excel* ultraedit
4 Comments1 Solution152 ViewsLast Modified:
I've got a data export file from a system that contains Unicode data, but part of the flow to upload this into the target requires removing these extended characters.  I have to pull the data through Excel and into another tool.  Excel seems to error on these (not sure why, but it currently is).

I'm looking for a way to convert all characters that are above the ASCII character set into a '*' character using either VIM or UltraEdit (2 tools I have available to me).  There are a range of these characters and I don't know what all they are so I need something that isn't just matching on an individual character but a range of character values.

Does anyone know a regex in VIM or a way to do something like this in UltraEdit?
Systems architect
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros