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

From |
"Prashant Shukla" <PShukla@globalshares.com> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
RE: st: outsheet txt files with one space between columns |

Date |
Tue, 9 Dec 2008 17:57:45 -0000 |

Thanks Jochen. Yes, now I notice it too. I think -outsheet- with -char(" ")- option produces columns separated by more than one space when we have blank column. Now a new problem arises here, a blank column formatted as a string of length, say 5, still appears as only one space instead of 5. Do I need to manually set the blank columns to be equal to " "? I will try -outfile- using the -comma- option and see how that goes. Thanks again, -Prash. -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Jochen Späth Sent: Tuesday, December 09, 2008 10:47 AM To: statalist@hsphsun2.harvard.edu Subject: AW: st: outsheet txt files with one space between columns I just tried using -outsheet- with the -char(" ")- option, however, this produces in some cases data field separated by more than one space, too. I have no solution to your problem, but maybe it would be a good workaround to -outfile- your data using the -comma- option. Having done so, open the new file with an editor of your choice, replace every instance of repeated commas (e.g. ",,,,,") by one single space first and then replace the remaining instance of only one comma with one space, too. Hope this helps, Jochen ------------------------------------------------------------------------------------------- Jochen Späth Dipl.-Volkswirt Institut für Angewandte Wirtschaftsforschung (IAW) Tübingen Ob dem Himmelreich 1 72074 Tübingen Tel.: +49-(0)7071-9896-14 Fax: +49-(0)7071-9896-99 EMail: jochen.spaeth@iaw.edu IAW-Homepage: www.iaw.edu ------------------------------------------------------------------------------------------- -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Dan Weitzenfeld Gesendet: Dienstag, 9. Dezember 2008 18:33 An: statalist@hsphsun2.harvard.edu Betreff: Re: st: outsheet txt files with one space between columns -help outsheet- says to try the option delimiter("char") e.g., outsheet using "filename.txt", delimiter(" ") On Tue, Dec 9, 2008 at 9:19 AM, Prashant Shukla <PShukla@globalshares.com> wrote: > Hi All, > > I am using -outsheet- to transfer data as txt files. The file needs to > be loaded into a system which requires only one space between the > columns. This is because the files need to be fixed with and when they > are tab separated, they have multiple spaces between the columns. So the > file ends up not being the width we want and all the columns after the > first one do not have the required start and end positions. > > ------------------------------------- > > For instance, what I have is: > > 1001 1002 1003 1004 1005 > > What I need is: > > 1001 1002 1003 1004 1005 > ------------------------------------- > > Is there a way to define a tab as being one space? Or, is there another > way to accomplish this goal of one space between columns in a txt files > with Stata or Stat/Transfer(I have that too)? > > Thanks so much everyone, > > -Prash. > > > * > * 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/ > -- Dan Weitzenfeld Media Analyst EmSense Corporation 512 2nd Street, 3rd Floor San Francisco, CA 94107 w: 415.418.7314 m: 510.552.0106 dan.weitzenfeld@emsense.com * * 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/

**References**:**st: outsheet txt files with one space between columns***From:*"Prashant Shukla" <PShukla@globalshares.com>

**Re: st: outsheet txt files with one space between columns***From:*"Dan Weitzenfeld" <dan.weitzenfeld@emsense.com>

**AW: st: outsheet txt files with one space between columns***From:*Jochen Späth <jochen.spaeth@iaw.edu>

- Prev by Date:
**Re: st: outsheet txt files with one space between columns** - Next by Date:
**RE: st: outsheet txt files with one space between columns** - Previous by thread:
**AW: st: outsheet txt files with one space between columns** - Next by thread:
**RE: st: outsheet txt files with one space between columns** - Index(es):

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