Statalist


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

Re: st: Getting rid of line-breaks in Data


From   Matt Spittal <Matt.Spittal@cancervic.org.au>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Getting rid of line-breaks in Data
Date   Fri, 19 Jun 2009 10:32:33 +1000

Dear Elmar,

Carriage returns can be very difficult to deal with. I don't have any clear
answers, except to say that I have found a good text editor to be invaluable
for cleaning a file. For instance, with my text editor (TextWrangler) I can
change between UNIX, Windows and Mac carriage returns and I can use grep
functions to find and replace symbols like the carriage return. If you can
export your data from Access as a text file (csv) and then clean it within a
text editor, then this might be a good solution.

I am not sure what computer system or text editor you are using at present,
but some very good advice on text editors is given here.

    http://fmwww.bc.edu/repec/bocode/t/textEditors.html

Good luck,

-- Matt
matt.spittal@cancervic.org.au




On 18/6/09 5:28 PM, "Elmar Saathoff" <elmarsaathoff@gmx.net> wrote:

> Dear list members,
> 
> I am frequently using data that were imported from PDAs via MsAccess. In
> some cases these data contain some little squares that do not seem to do
> much harm in Stata, but that other applications interpret as
> linebreaks/carriage returns/paragraph marks, which is quite a hassle. It
> seems that these things are inadvertently entered into the PDAs by the
> people collecting the data. Unfortunately I cannot show them in this
> email, because my email client also interprets them as carriage returns.
> Anyway, I have been trying to identify and get rid of these things by
> programming (using "subinstr", "egen...split" etc.), but unfortunately,
> whatever I do, Stata also interprets them as carriage returns, both in
> do files and in the command window, even if I change the delimiter to
> ";" via the delimit command.
> 
> Any advice would be greatly appreciated.
> 
> Thanks in advance, Elmar
> *
> *   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/



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