Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Problems with insheet with non-standard delimiter ø
From
Lucas Ferreira Mation <[email protected]>
To
statalist <[email protected]>
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/