Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

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

From |
tashi lama <ltashi32@hotmail.com> |

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

Subject |
RE: st: Use Regular Expressions to replace words/strings of characters in a text file |

Date |
Thu, 16 Aug 2012 15:02:33 +0000 |

I got the general idea to execute( to read line by line and check and drop) but I am lacking a machinery. So, I go file open myfile using tt.xml, read write file read myfile line **here I need to say delete the `line' if strpos("`line'","table"). I can't find the way to delete the line. Any idea? Thanx.. ---------------------------------------- > From: ltashi32@hotmail.com > To: statalist@hsphsun2.harvard.edu > Subject: RE: st: Use Regular Expressions to replace words/strings of characters in a text file > Date: Wed, 15 Aug 2012 17:24:21 +0000 > > Thanx . I did look into file before posting this. I will look into more carefully. Thanx. \ > ---------------------------------------- > > Date: Wed, 15 Aug 2012 18:20:53 +0100 > > Subject: Re: st: Use Regular Expressions to replace words/strings of characters in a text file > > From: njcoxstata@gmail.com > > To: statalist@hsphsun2.harvard.edu > > > > No and no. -filefilter- is only part of the answer. If your problems > > were mine, I would be processing the file with -file- statements. You > > would have to read in each line and process it. That could include > > setting markers for when you are in certain parts of the file and are > > prepared to make particular changes. > > > > There is no objection, naturally, to do your doing that with any > > scripting language you know. But my impression is that your problem is > > programmable in Stata. > > > > Nick > > > > On Wed, Aug 15, 2012 at 4:59 PM, tashi lama <ltashi32@hotmail.com> wrote: > > > Thanx. This is great although it seems that its options are limited. Are there ways to pull the followings around > > > 1. filefilter tt1.xml tt2.xml, from("Worksheet") to("") removes worksheet from the file. What if I have a block of characters that I need to remove? Is there a way to say like I want all the characters removed that occur before string table( first occurence of table since there might be multiple strings table in the text)? > > > 2. This might be a redundant of the last part of the first question. Since there are no options in filefilter saying look the pattern only from here to here like in subinstr("fafaa","a","t",1) to mean replace first a or subinstr("fafaa","a","t",.) to mean replace all a, is there a way to do search and replace for only part of the text? > > > > > > Thanx tons.. > > > Tashi > > > ----------------------------- > > >> Date: Wed, 15 Aug 2012 01:07:39 +0100 > > >> Subject: Re: st: Use Regular Expressions to replace words/strings of characters in a text file > > >> From: njcoxstata@gmail.com > > >> To: statalist@hsphsun2.harvard.edu > > >> > > >> -help filefilter- > > >> > > >> Nick > > >> > > >> On Tue, Aug 14, 2012 at 9:18 PM, tashi lama <ltashi32@hotmail.com> wrote: > > >> > > >> > I looked for previous posts and read and still can't find the solution. I could use stata's string functions(regexr, subinstr etc) to search and replace string in a string. But if I have a text file(test1.xml) that I need to run a search and replace on, how do I do it? Putting a text in a local macro( put aside the macro limitation) and using regexr wouldn't be an option because I have to generate a xml file from the dataset. > > >> > > > >> > view test1.xml > > >> > > > >> > <?xml version="1.0" encoding="US-ASCII" standalone="yes"?> > > >> > <?mso-application progid="Excel.Sheet"?> > > >> > <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" > > >> > > >> * > > >> * 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/ > * > * 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/

**Follow-Ups**:**Re: st: Use Regular Expressions to replace words/strings of characters in a text file***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: Use Regular Expressions to replace words/strings of characters in a text file***From:*tashi lama <ltashi32@hotmail.com>

**Re: st: Use Regular Expressions to replace words/strings of characters in a text file***From:*Nick Cox <njcoxstata@gmail.com>

**RE: st: Use Regular Expressions to replace words/strings of characters in a text file***From:*tashi lama <ltashi32@hotmail.com>

**Re: st: Use Regular Expressions to replace words/strings of characters in a text file***From:*Nick Cox <njcoxstata@gmail.com>

**RE: st: Use Regular Expressions to replace words/strings of characters in a text file***From:*tashi lama <ltashi32@hotmail.com>

- Prev by Date:
**st: Problem with grid lines in twoway plot** - Next by Date:
**Re: st: CommandLineEmailer using gmail ??** - Previous by thread:
**RE: st: Use Regular Expressions to replace words/strings of characters in a text file** - Next by thread:
**Re: st: Use Regular Expressions to replace words/strings of characters in a text file** - Index(es):