Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Problems with insheet with non-standard delimiter ø


From   Lucas Ferreira Mation <lucasmation@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: Problems with insheet with non-standard delimiter ø
Date   Tue, 31 Jul 2012 00:34:38 -0300

Dear Statalisters,

I´m having problems exporting data from MS SQL database (where we
build the queries) to Stata. I exported data as a .txt file with the
character   ø  as the delimiter. The idea was to avoid problems with
the delimiter appearing in the middle of the field and messing the
data.

insheet using "example_table.txt", delimiter(ø) clear  //  >> does not
work. All the fields are put  in just one variable, inside which you
can see that the  " ø "  became " ø " .

I tried using "filefilter" but the  ø   character was also not
recognized/replaced. Any ideas on what I could do? Which delimiters
that are rare (perhaps non-printable) can be easily interpreted by
Stata?

bellow I copy a sample of the data in the txt file and how it looks
after the problematic insheet.

regards
Lucas



In the .txt file, the data is like this:

8751ø2838øthis is a test nameø33313342000ø452050773214ø457001øNULLøNULL
14535ø2838øthis is a test nameø33313342000ø452050773214ø457001øNULLøNULL
18426ø2838øthis is a test nameø33313342000ø452050773214ø457001øNULLøNULL

After insheet it becomes this:

8511ø2838øthis is a test
nameø33313342000ø452050773214ø457001øNULLøNULL
14535ø2838øthis is a test nameø33313342000ø452050773214ø457001øNULLøNULL
18426ø2838øthis is a test nameø33313342000ø452050773214ø457001øNULLøNULL

*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index