Convert Binary text to regular text

[Ben Reynders]

How do you convert a binery text to a regular text?

[Ghost308]

I'm not sure I understand what you mean... if you are trying to do this for string comparisons you can add the line..


option Compare Text




...to the top of your module. then all text being compared is used case-insensitive as opposed to the case-sensitive "Option Compare Binary". I hope this is in the right direction of what you are looking for! good luck!

jeff

[Cimperiali]

Here you find Iouri make it reverse (from text to binary). You can reverse it to get what you want:
http://codeguru.com/cgi-bin/bbs/wt/s...age=0&Limit=25

However, if binary number is ascii number, after you convert it in decimal, simply pass it to CHR() function...


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

[Cimperiali]

Sorry, I did not see it was "binary text". Did you mean how to read a binary file? Here is the solution:

http://codeguru.com/cgi-bin/bbs/wt/s...age=0&Limit=25

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

[Cakkie]

You can use the StrConv function to do that, which can convert a byte array to a string, or the other way around. For that, you must specify the vbToUnicode of vbFromUnicode parameter.

Tom Cannaerts
[email protected]
Moderator on http://www.vbcodelibrary.co.uk/board

A bottomless pit, I'm sure it came with the place, who would dig one on purpose?