LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Cannot Dechiper Encoded String

I pull a text string off a web page, that contains some random text.
From time to time, the string will contain a mixture of ASCII and ISO
encoded characters. Sample below.

I'm unable to get any function to recognize the string.

I'm using VBA 6.0 with Excel 2000

Example code:

Subject= "Auction"

Subject = Replace(Subject, "B", "A")

I've also tried every other character that should be in that string.

The replacement never takes place, the string is unmodified. I've
also tried searching for just "&#" but it never finds that either.
I've tried using InStr as well but that fails to find a match too.
The goal is of course to dechiper the (random) string into it's ASCII
equivalent (so that it can be read by a human).

Any help?

Thank you in advance

- Dudely
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create dialog box that will post to worksheet encoded data? joromajr Excel Discussion (Misc queries) 1 November 1st 09 12:16 PM
Excel docs opening encoded jackievar Excel Discussion (Misc queries) 3 November 10th 07 08:40 PM
Opening UTF8-encoded CSV file (Excel 2004 for Mac) Antonio[_2_] Excel Discussion (Misc queries) 2 October 30th 07 10:30 PM
How to open a UTF-8 encoded CSV file in Excel Elayaraja Excel Discussion (Misc queries) 3 April 18th 06 11:26 AM
Importing UTF-8 Encoded CSV Files. Problem Rob[_12_] Excel Programming 0 September 4th 03 12:59 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"