Re: st: RE : st: Insheet Issue

["Michael N. Mitchell" <Michael.Norman.Mitchell@gmail.com>]

Dear Antonio

  I would suggest checking out the -hexdump- and -filefilter- commands within Stata. The 
-hexdump- command, with the -analyze- option will give you a kind of frequency 
distribution of all of the different characters in your file. This will allow you to 
identify any nasty bits in your file (i.e., non-ASCII characters).

  You can then use the -filefilter- command to convert those nasty characters into 
something more innocuous (that would not bother -insheet-).

  This solution takes a little time and patience, but I think it will get you to where 
you want to go.

Best luck!

Michael N. Mitchell
Data Management Using Stata      - http://www.stata.com/bookstore/dmus.html
A Visual Guide to Stata Graphics - http://www.stata.com/bookstore/vgsg.html
Stata tidbit of the week         - http://www.MichaelNormanMitchell.com



On 2010-09-11 12.42 PM, Vezzani, Antonio (EST) wrote:
> I checked the file: in the last row uploaded there is an arrow in a cell
> string, I've tried to delete it but still doesn't work, and the null cells
> are already empty...any other suggestion?
>
>
>
> -------- Message d'origine--------
> De:	owner-statalist@hsphsun2.harvard.edu de la part de Ronan Conroy
> Date:	sam. 11/09/2010 18:35
> À:	statalist@hsphsun2.harvard.edu
> Cc:	
> Objet:	Re: st: Insheet Issue
>
> On 10 MFómh 2010, at 21:46, Jeph Herrin wrote:
>
> > Perhaps an embedded | or<carriage return>; or an empty
> > row. Have you tried inspecting line 164,502 of the ASCII file?
>
> Another nightmare character is the 'Null' character.
>
> Try opening your data in a text editor and giving a 'convert to ASCII'
> command.
>
> If you don't have a text editor that does this, you might look at the
> text editor FAQ and get one as a priority. Very useful for data
> cleaning!
>
>
>
> Ronán Conroy
> Associate Professor
> Division of Population Health Sciences
> =================================
>
> rconroy@rcsi.ie
> Royal College of Surgeons in Ireland
> Epidemiology Department,
> Beaux Lane House, Dublin 2, Ireland
> +353 (0)1 402 2431
> +353 (0)87 799 97 95
> +353 (0)1 402 2764 (Fax - remember them?)
> http://rcsi.academia.edu/RonanConroy
>
> P    Before printing, think about the environment
>
>
>
>
>
> *
> *   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/