RE: [ACFUG Discuss] How to trap bad character - diamond with question mark.

[axunderwood]

What is the specific problem you're having with it?


From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy
Sent: Monday, May 04, 2009 8:19 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] How to trap bad character - diamond with question mark.

Does anyone have a quick fix for the black diamond with a question mark?

Over the years, I've tried all kinds of things and nothing seems to work. 
Currently, this is in some data that I am importing from another system, so I 
can't avoid having to deal with it.

_
Derrick Peavy
derr...@derrickpeavy.com
_






-

To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by http://www.fusionlink.com

-

RE: [ACFUG Discuss] How to trap bad character - diamond with question mark.

[Clarke Bishop]

In the past, it has usually helped me to find the ASCII value for the bad
character. I'm not sure exactly which character you mean.

 

You might have to get some text with the bad character and the parse it out
character by character to find the bad one.

 

Then, just do a find and replace anywhere that text might occur.

 

Hope this helps!

 

Clarke

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy
Sent: Monday, May 04, 2009 8:19 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] How to trap bad character - diamond with question
mark.

 

Does anyone have a quick fix for the black diamond with a question mark? 

 

Over the years, I've tried all kinds of things and nothing seems to work.
Currently, this is in some data that I am importing from another system, so
I can't avoid having to deal with it. 


_

Derrick Peavy

derr...@derrickpeavy.com

_





 




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] How to trap bad character - diamond with question mark.

[Scott Weikert]

Derrick Peavy wrote:
Does anyone have a quick fix for the black diamond with a question mark? 

Over the years, I've tried all kinds of things and nothing seems to 
work. Currently, this is in some data that I am importing from another 
system, so I can't avoid having to deal with it. 
*

*

http://www.cflib.org/index.cfm?event=page.udfbyid&udfid=725

Try grabbing the UDF linked above, and pushing your text string through it.

You may need to do some editing of it for your own purposes as well, but 
it's pretty straightforward.


--Scott


-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-