I need a tool but I don't know which ...

Discussion in 'General Chat' started by Kngavl, Jan 7, 2008.

  1. #1
    Okay I'm filtering through content and I'm copying down lists,

    So when I copy and paste I get.

    Name # % X XX
    Name # % X XX
    Name # % X XX
    Name # % X XX
    etc.

    However to speed up the process I only need the name, how do I remove the # % X XX (thats just and example) so I only get a list of names?
    I hope this makes sense, and is their a program to do it? Like I could use the replace tool except the data is different in every field so It would still be faster to manually remove it.
     
    Kngavl, Jan 7, 2008 IP
  2. mvandemar

    mvandemar Notable Member

    Messages:
    2,409
    Likes Received:
    307
    Best Answers:
    0
    Trophy Points:
    230
    #2
    What you need is a text editor that supports RegEx search and replace. I use (and love) NoteTab Light.

    It allows you to search by patterns instead of exact strings. Very useful. You need to know a little bit about how regular expressions (RegEx) work, but it's not that hard to learn, and very powerful once you do.

    -Michael
     
    mvandemar, Jan 7, 2008 IP
  3. Kngavl

    Kngavl Peon

    Messages:
    964
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Okay, I'll try it out thank you mate.
     
    Kngavl, Jan 7, 2008 IP
  4. Kngavl

    Kngavl Peon

    Messages:
    964
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Okay new problem, this is driving me nuts argh. Okay so I have now a huge list of names, however each is on it's own line and I need them all to be single spaced between each other.
    Any ideas?
     
    Kngavl, Jan 7, 2008 IP
  5. DomainCo.US

    DomainCo.US Well-Known Member

    Messages:
    2,124
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    100
    #5
    get a text editor that lets you record keystrokes (editplus)... ex for above find #, then press shift end to highlight # until end of line, then delete... repeat the steps as necessary
     
    DomainCo.US, Jan 7, 2008 IP
  6. mvandemar

    mvandemar Notable Member

    Messages:
    2,409
    Likes Received:
    307
    Best Answers:
    0
    Trophy Points:
    230
    #6
    You need to replace the ends of the lines with spaces? So this:
    test1
    test2
    test3

    becomes:
    test1 test2 test3?

    If so, and if you are using NoteTab Light, use the normal search and replace, and replace the new lines using the ^P (which means paragraph) symbol. So find:
    ^P
    and replace them all with a space.

    -Michael
     
    mvandemar, Jan 7, 2008 IP
  7. Kngavl

    Kngavl Peon

    Messages:
    964
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #7
    LOL I eventually, not willing to accept defeat, manually pressed (home), which brought me to the beginning of the line and then backspace, over 450 times. Ugh.
    Thank you for the tips, I'll keep it in mind for next time, lol
     
    Kngavl, Jan 7, 2008 IP
  8. Dimpi

    Dimpi Peon

    Messages:
    191
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    What do you think, we are here to solve your personal problems.
     
    Dimpi, Jan 7, 2008 IP
  9. hextraordinary

    hextraordinary Well-Known Member

    Messages:
    2,171
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    105
    #9
    do a search for "awk", can fix this in 3 seconds :D
     
    hextraordinary, Jan 8, 2008 IP