special character

[Lombardo, Barbara]

Good Morning,

 

Downloads from our main database include this character �  as a field delimiter.   When I do a search/replace in SPSS for this character that I have cut/paste in, it cannot find it.  I take the file to EXCEL and it can find and replace it???  Don’t really feel like going through this extra step, any suggestions?

 

Thank you

 

 

Barbara Lombardo

 

CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system.

 

<script type="text/javascript"> <!-- if (top.location != self.location) top.location = self.location; // --> </script>   ­­   ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Jon K Peck]

You have characters that are invalid in the current encoding in Statistics or perhaps it is a nonprinting character.  You need to find out what character it is, assuming it is just one.  Change a field that shows this to AHEX format (syntax is required FORMAT x (AHEXnn) where nn is 2 x string width).

Then code such as this would replace it
compute strvar = replace(strvar, string(10, pib1),' ')
(That's for a carriage return character.)
You can put this in a do repeat loop if many variables are involved.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Ruben Geert van den Berg]

For some more background and examples on this matter, see http://www.spss-tutorials.com/convert-characters-to-codepoints-and-reversely/.

HTH,

Ruben