- VBA
- Microsoft Excel
- Microsoft Office
Need to replace all characters above ASCII with '*' (or similar)
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?
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?
-
![]()
received a Solution
Generate lots of similar numbers (all having the same make-up) based on a manually entered number using a macro -
![]()
wrote an Article
![]()
Creating a legend for conditional formatting in Excel 2016 and a hyperlink to that legend
-
![]()
created a Video
![]()
How To Insert Foreign and Special Characters when in Windows Applications
-
Explore Cloud Class® ![]()
Microsoft Office Excel 2019: Part 03
Premium Content
You need an Expert Office subscription to comment.Start Free Trial