///
Dan,
I cannot reply your problem (copying your line in a text gives me ???, 0, ??? then command works fine to me) and maybe many users will be in the same position. My two cents here are: (1) If file is small (less than 65000 obs) you could make up it with Excel or similar package. (2) If you could open it with Wordpad or Notepad, you could change commas for something else like $$$$ and trying to use -insheet- with that separator.
Good luck,
Rodrigo.
-----Mensaje original-----
De: [email protected] [mailto:[email protected]] En nombre de Dan Weitzenfeld
Enviado el: Martes, 23 de Septiembre de 2008 02:08 p.m.
Para: [email protected]
Asunto: Re: st: Insheeting Japanese
Thanks Sergiy, I did not know about that command. Below is a line from my hexdump:
130 | 304b ff1f 002c 0031 002c 0032 000d 000a | 0K...,.1.,.2....
I also noticed this when I ran with option Analyze:
Line-end characters
\r\n (Windows) 0
\r by itself (Mac) 5
\n by itself (Unix) 5
which looks suspicious to me. I'll talk to the tech guys who made this file.
Thanks again Sergiy.
On Tue, Sep 23, 2008 at 10:51 AM, Sergiy Radyakin <[email protected]> wrote:
> Dear Dan,
>
> how data "looks like" depends on, which software "looks" at it. From
> what I see in your message, there is double-byte encoding of letters
> which may cause a problem.
>
> I suggest you first "look" at your data byte-by-byte, to find a
> pattern you need, then filter your data based on that pattern.
> Use
> -hexdump- filename
> to see how your data is structured. Check that you are using correct
> separator "comma" and not "tab", that "comma" in your file is indeed a
> standard ASCII "comma" and not some weird two-bytes comma, that a
> "comma" byte (44) is not used for encoding other characters, etc.
>
> Perhaps you could post a portion of output from hexdump here if this
> does not contradict any rules of the list.
>
> Regards, Sergiy Radyakin
>
>
> On Tue, Sep 23, 2008 at 1:09 PM, Dan Weitzenfeld
> <[email protected]> wrote:
>> Hi All,
>> Quick but strange question. I'm trying to insheet a comma-delimited
>> file with Japanese in it. For example, the first line looks like:
>>
>> あなたはこのＣＭが好きですか？,0,とても好き
>>
>> The only information I need is the second variable, the 0, which will
>> always be numeric.
>>
>> However, when I insheet the file, I get nonsense:
>>
>> þÿ0B0j0_0o0S0nÿ#ÿ-0LY}0M0g0Y0Kÿ 0h0f0‚Y}0M
>>
>> which would be okay, except that the second variable always comes in as blank.
>>
>> Does anyone know of a solution for this?
>>
>> Thanks in advance,
>> Dan
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
********************************************************************************
ADVERTENCIA: La información contenida en esta transmisión, y en cualquier archivo adjunto, está sujeta a reserva legal conforme a la normativa aplicable al Banco Central de Chile, y no puede ser usada o difundida por personas distintas de su o sus destinatarios. Si usted ha recibido esta transmisión por error, por favor notifique inmediatamente al remitente respondiendo por este mismo medio y elimínela de su sistema.
El Banco Central de Chile no se hará responsable de la exactitud y veracidad de la información contenida en este mensaje, así como de su modificación, copia, divulgación o reenvío, total o parcial. Su uso no autorizado puede ser sancionado de conformidad con las leyes chilenas.
El Banco Central de Chile transmite sus decisiones a través de comunicados oficiales, los que pone a disposición del público en su página de Internet: www.bcentral.cl
DISCLAIMER: The information contained in this email or any attached file, is subject to legal privilege pursuant to the laws and regulations applicable to the Central Bank of Chile , and may not be used or disseminated by any person other than its intended recipients. If you have received this transmission in error, please notify the sender immediately by reply to this email address and delete it from your system.
The Central Bank of Chile shall not be liable for the accuracy or authenticity of the contents of this message, whether amended, copied, forwarded or disclosed in any form, in whole or in part. Please note that unauthorized use may be penalized in conformity with the Chilean law.
The Central Bank of Chile communicates its decisions by official releases, and
makes them available to the public in its WebPages: www.bcentral.cl
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
