Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #80441

Re: Python script that does batch find and replace in txt files

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path <khalidness@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.004
X-Spam-Evidence '*H*': 0.99; '*S*': 0.00; 'skip:[ 20': 0.04; 'syntax': 0.04; 'subject:Python': 0.06; 'automate': 0.07; 'is"': 0.07; '&quot;)': 0.09; 'cursor': 0.09; 'line:': 0.09; 'rows': 0.09; 'subject:files': 0.09; 'subject:script': 0.09; 'trailing': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; 'posted': 0.15; '"_")': 0.16; '.txt': 0.16; 'email addr:yahoo.com&gt;': 0.16; 'is&quot;': 0.16; 'newlines': 0.16; 'recorded': 0.16; 'subject:txt': 0.16; 'syntaxerror:': 0.16; 'the"': 0.16; 'files.': 0.16; 'folder': 0.16; 'wrote:': 0.18; 'file,': 0.19; 'skip:g 40': 0.19; 'select': 0.22; 'import': 0.22; 'email addr:gmail.com&gt;': 0.22; 'cc:addr:python.org': 0.22; 'error': 0.23; 'replace': 0.24; 'script.': 0.24; 'skip:l 30': 0.24; 'mon,': 0.24; 'file.': 0.24; 'cc:2**0': 0.24; 'script': 0.25; '&gt;': 0.26; 'query': 0.26; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'characters': 0.30; 'skip:g 30': 0.30; 'message-id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'getting': 0.31; 'lines': 0.31; '&quot;': 0.31; 'subject:that': 0.31; 'txt': 0.31; 'file': 0.32; 'option': 0.32; 'run': 0.32; 'text': 0.33; 'open': 0.33; 'up.': 0.33; 'url:python': 0.33; '-----': 0.33; 'something': 0.35; 'etc': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'done': 0.36; 'url:listinfo': 0.36; 'url:org': 0.36; 'email addr:python.org': 0.37; 'step': 0.37; 'skip:& 10': 0.38; 'thank': 0.38; 'nov': 0.38; 'skip:[ 10': 0.38; 'files': 0.38; 'skip:& 20': 0.39; 'does': 0.39; 'subject:': 0.39; 'delete': 0.39; 'space': 0.40; 'url:mail': 0.40; 'remove': 0.60; 'blank': 0.60; 'skip:\xc2 10': 0.60; 'break': 0.61; 'name:': 0.61; 'kindly': 0.61; 'you.': 0.62; 'save': 0.62; 'email name:python-list': 0.65; 'reply': 0.66; 'invalid': 0.68; 'skip:w 30': 0.69; 'containing': 0.69; 'to:addr:yahoo.com': 0.81; '"contact': 0.84; '10:': 0.84; '11:': 0.84; '12:': 0.84; '13:': 0.84; '14:': 0.84; 'no:': 0.84; 'subject:find': 0.84; 'syed': 0.84; '|house': 0.84; 'opens': 0.91
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=QGP7JAnK8URMfBYmS3K8rqUcsGeWgcR4ViRhduUmHl0=; b=0O/c7gOH1DQ/Jxtupq8O8ekIvOEM577C52v+cfIr4uVtriRMARBAR83cDK+EiTaK0q WDaib4D/trL73q2Apw5/3nws1rUCN0nLQOtluXWSoG9JfXTZljABKoi+s79eCx79oKGq sUjmJ4vTLGcGT50WJ6R6yFsPw2FPJNL2A4AZbMpDgeXpBgkppg2WzQd87gUG54CmbXyh ww3fBnEi7uf6dYF8I9BT++hbG+uEVZ8YMp/S8yr0VVsg11uEbcgT/V2kd+xwMcVkkkXb /LCu5VC7kgGjIQ8Its6utqlpOO7xO0lKCnK13r5yA8x3Fe7SPBDfgDAYDydaY8N0CTw3 GgeQ==
MIME-Version 1.0
X-Received by 10.152.20.199 with SMTP id p7mr25533863lae.49.1415566355937; Sun, 09 Nov 2014 12:52:35 -0800 (PST)
In-Reply-To <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com>
References <e9ee1f6f-9397-4dc5-a357-381ebc9b6e57@googlegroups.com> <46769509.90793.1415564600851.JavaMail.yahoo@jws10740.mail.gq1.yahoo.com>
Date Mon, 10 Nov 2014 02:22:35 +0530
Subject Re: Python script that does batch find and replace in txt files
From Syed Khalid <khalidness@gmail.com>
To Albert-Jan Roskam <fomcl@yahoo.com>
Content-Type multipart/alternative; boundary=089e0141a520cd4002050773396c
Cc "python-list@python.org" <python-list@python.org>
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.15
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.15608.1415566358.18130.python-list@python.org> (permalink)
Lines 196
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1415566358 news.xs4all.nl 2831 [2001:888:2000:d::a6]:40710
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:80441

Show key headers only | View raw


[Multipart message — attachments visible in raw view] - view raw

Hi Albert,

Thank you for script.

I am getting the below error :

  File "EamClean.log", line 12
    with codecs.open(txt + "_out.txt", "wb", encoding="utf-8") as w:
       ^
SyntaxError: invalid syntax

Kindly do the needful.

On Mon, Nov 10, 2014 at 1:53 AM, Albert-Jan Roskam <fomcl@yahoo.com> wrote:

>
>
>
>
> ----- Original Message -----
> > From: Syed Khalid <khalidness@gmail.com>
> > To: python-list@python.org
> > Cc:
> > Sent: Sunday, November 9, 2014 8:58 PM
> > Subject: Python script that does batch find and replace in txt files
> >
> > Python script that does batch find and replace in txt files Need a
> python script
> > that opens all .txt files in a folder find replace/delete text and save
> files.
> >
> > I have text files and I need to perform below steps for each file.
> >
> > Step 1: Put cursor at start of file and Search for "Contact's
> > Name:". Delete all the rows before it.
> > Step 2: Put cursor at end of file, Search for "Contact's Name:"
> > select option UP.
> > Step 3: Search for "Photo of the" Replace with blanks
> > Step 4: Search for "Contact is" Replace with blanks
> > Step 5: Search for "Contact's Name:" Replace with blanks
> > Step 6: Search for "Age:" Replace with blanks
> > Step 7: Search for "Sex:" Replace with blanks
> > Step 8: Search for "House No:" Replace with blanks
> > Step 9: Search for "available" Replace with blanks
> > Step 10: Remove Empty Lines Containing Blank Characters from file
> > Step 11: Trim Leading Space for each line
> > Step 12: Trim Trailing Space after each line
> > Step 13: Search for - (hyphen) Replace with _ (underscore)
>
> > Step 14: Save file.
>
> something like (untested)
>
>
> import glob, codecs, re, os
>
> regex = re.compile(r"Age: |Sex: |House No: ") # etc etc
>
> for txt in glob.glob("/some/path/*.txt"):
>     with codecs.open(txt, encoding="utf-8") as f:
>         oldlines = f.readlines()
>     for i, line in enumerate(oldlines):
>         if "Contact's Name: " in line:
>             break
>     newlines = [regex.sub("", line).strip().replace("-", "_") for line in
> oldlines[i:]
>     with codecs.open(txt + "_out.txt", "wb", encoding="utf-8") as w:
>         w.write(os.linesep.join(newlines))
>
>
>
>
> >
> > Currently I have recorded a macro in Notepad++.
> > I open each file, run macro and save file.
> > As there are many files I was looking for a program to automate the
> process.
> >
> > I posted the same query in Notepad++ forum. I got a reply that it can be
> done by
> > using Python script.
> >
> > Kindly do the needful.
> >
> > Thank you.
> > khalidness
> >
> > --
> > https://mail.python.org/mailman/listinfo/python-list
> >
>

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-09 11:58 -0800
  Re: Python script that does batch find and replace in txt files Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-11-09 20:17 +0000
  Re: Python script that does batch find and replace in txt files Albert-Jan Roskam <fomcl@yahoo.com> - 2014-11-09 20:23 +0000
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 02:22 +0530
    Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-09 13:08 -0800
      RE: Python script that does batch find and replace in txt files "Clayton Kirkwood" <crk@godblessthe.us> - 2014-11-09 15:03 -0800
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 02:50 +0530
  Re: Python script that does batch find and replace in txt files MRAB <python@mrabarnett.plus.com> - 2014-11-09 21:44 +0000
  Re: Python script that does batch find and replace in txt files Syed Khalid <khalidness@gmail.com> - 2014-11-10 03:21 +0530
  Re: Python script that does batch find and replace in txt files Denis McMahon <denismfmcmahon@gmail.com> - 2014-11-11 20:04 +0000

csiph-web