Community

I have a file with 100's of lines similar to this line;

41.6750,-81.4217,PGas,700 Cty Rd H,Elkharden,WA,362-623-5410

I want to end up with; comma's replaced w/ spaces around state abbr.

41.6750,-81.4217,PGas,700 Cty Rd H,Elkharden WA 362-623-5410

I've tried doing it a couple of ways but my ...

Thanks for the quick response. I'm still trying to learn about this stuff. I do have another question related to my first one.

What if I wanted to REPLACE, instead of DELETE the information?
Example:
- American Canyon NEW TXT #1651,
- Anaheim NEW TXT #2242,
- Anderson NEW TXT #5133,
- Antelope ...

- American Canyon #1651,
- Anaheim #2242,
- Anderson #5133,
- Antelope #1881,
- Bakersfield #1574,
- Bakersfield #5134,
- Baldwin Park #3522,
- Beaumont #5156,
- Brawley #5335,

I have the above text in a file. I want to search for anything that's between the hyphen '-' and the pound sign '#' and ...

Ben, I wonder if you could talk me through the syntax of this line you provided? Including the "Replace with". It gets a little confusing. Especially when I try to test some of the different methods. A couple of times the \1\2 etc. doesn't work the way I'd expect and then I get stuck. I think I've ...

Thanks ben, very helpful.

I have a file with approx. 1000 lines with over half of the lines that begin with RV... following the third comma, similar to this.

3488,10033,some txt, RV text,I-80 Exit 2,Big Lake,ID,84822,(423)405-1191,

I'd like to move the part that begins with "RV to next comma", ie. "RV text", and add it to ...

Thanks Bob

Your explanation is very helpful. I learn a little more each day.

I'm sorry to post this, but I can't find what I'm looking for by searching the forum. I'm having a hard time understanding the \1\2 etc. in the Replace with:

Example: note, there is a space before and after each state abbrev.

52 E Columbia St: Othello: WA (509) 488-2312
201 State Highway 59 ...

Thanks, but when I tried your expression it didn't work. I did however drop the $ behind the TX, so:

Find what: .*,?TX did work.

What does the $ supposedly do?

Ames, TX
710 East Main Street
Cedar Grove Park
Anahuac, TX
1512 South Main Street
Trinity Bay
Anna, TX
Hwy. 75 Exit 48
715 South Central Expressway
Love's - Travel Stops

Can I have TextPad search for each of the lines with ,TX but then back up to the beginning of the City ahead of the ,TX and place ...

Thanks a lot that really helped. I'm getting there slowly but surely.

Takes a little getting used to, to figure out these Regular Expressions.

-94.1476, 36.3341,
-94.981617, 35.881339,
-94.22168, 36.36895,
-97.480064, 25.921765,
-104.6628, 38.23505,

This is a short section of hundreds of records in a large text file.

I want to add two zero's to the end of both sets of all numbers when the numbers only have four decimal places. -94 ...

Thanks a lot, both of you. Just what I needed. Also thanks for the references for Regular Expressions. I'll definitely look into Jeffrey Friedl's book.

Thanks for the info... both of you. Even after reading the Help file, I still don't quite understand the code.

Would you mind terribly, if I asked you to explain in layman's language what each of the RE codes mean?

I know the ^ by itself means Start of Line, and that the \n is the line return, but ...

I have the following text:
-110353,103080,This is a test,This is a test of more text\n
More test with numbers 9090909\n
520-393-2700\n
-110353,103080,This is a test,This is a test of more text\n
More test with numbers 9090909\n
520-393-2700\n
-110353,103080,This is a test,This is a test of more text ...