Community

Use "Posix" regular expression syntax: C onfigure | P references | Editor [ X ] Use P OSIX regular expression syntax S earch | R eplace... ( <F8> ): F i nd what: ([^|]+)\|([^|]+)\|([^|]+)\|([^|]+)\|([^|]+) Re p lace with: \2|\4|\1|\3|\5 [ X ] Regular e xpression Replace A ll Ben, I tried this and I ...

I have a pipe delimited file with data that looks like this ERFSYS1064|0718900798|1|S|2010-01-21 07:31:00 ERFSYS1032|0719600582|1|S|2010-02-17 11:00:00 ERFSYS1025|0719600582|1|S|2010-02-17 11:00:00 ERFSYS1025|0720801347|1|L|2010-01-18 16:30:00 ERFSYS1032|0722501524|1|S|2010-01-25 14:13:00 ERFSYS1025 ...

I have a CSV file with 3 columns Field1,Field2,Field3 Example 123,SLSSYS1000,1 123,SLSSYS1000,1 123,SLSSYS1008,1 323,SLSSYS1000,1 323,SLSSYS1008,1 323,SLSSYS1000,1 321,SLSSYS1008,1 321,SLSSYS1000,1 321,SLSSYS1000,1 I would like to change the 1 to 0 if Field2 does not match SLSSYS1008 So my output ...

Nevermind - Please delete

Thanks I got what I needed using WildEdit

I just bought WildEdit because as I understand it -It can handle variable length lines. I would like to clean up a large file so I can import it into a database. For each line starting with MV: I want to place place a | at the end Delete all but the first plot entry Remove PL: Remove BY: line I can ...

Thanks Ben, One more question - I just noticed that some of the movies have multiple BY: Is there a way to delete the section that is between a line that starts with BY: \n and ends with PL: \n So if I have **************************INPUT MV: Tobacco Road (1941) PL: Shiftless Jeeter Lester and his ...

I have a large file I'm performing some edits so I can import into a database. The file list the plots of several movies. The line starting with 'MV:' is the movie PL: is a line in the plot BY: is the person who added the plot For each movie I want to place a '|'(pipe) after the title and move the ...

I have several strings like this

10010 Kennerly Road, St. Louis, MO 63128
5 Maryland Plaza, St Louis, MO 63108-1501

How do I select
63128
63108

Find what: Submited By.*) With regular expression enabled and POSIX regular expression syntax enabled in the general preferences. Please note there is a space in front of 'Submited By'. The '.' character indicates find any character and the '*' means repeated zero or more times and then the search ...

My string looks like this

XXX1 Submited By Francis 2 ( xxxxxx @ hotmail . com ) XXX2
XXX1 Submited By Francis 1 ( xxcxxx @ gmail . com ) XXX3

I can find Submited By but how do I select up to )

I'd like to be left with
XXX1*XXX2
XXX1*XXX3

THanks
Steve

I have a large data file that I'm trying to cleanup in Textpad before importing into a new database.

In scanning the records I see characters like
br&gt - &lt - &#39
Are these character codes that got picked up in error?

How can I remove or convert this to the correct character?

I have a list with several URLS How do I find only lines that contain? ***linkedin.com/in/*** Thanks Steve SAMPLE LIST http://www.linkedin.com/in/johnmccain2008?PHPSESSID=a3b6642003125b34d213cd9819b1b36a http://ie.linkedin.com/pub/john-mitchell/4/586/5a9 http://uk.linkedin.com/in/johngoodwin http ...

All, I'm working with a list of filenames that contain a datetime stamp. example: "Change 69231 Ticket2008-10-01 14.48.18.953.xls" example: "Somename2008-10-01 14.48.18.953.pdf" example: "AnotherReport2008-10-01 14.48.18.953.htm" Would like to change to "Change 69231 Ticket.xls" or "Somename.pdf" or ...

I have several webpages I need to insert text into.

How can I find the last </p> in the file and insert text before the last </p>

So find
last instance of </p>

Replace with
****SOMETEXT \n </p>