1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need someone who is a regex expert using notepad++

Discussion in 'Hire a Freelancer' started by angelas111, Sep 12, 2015.

  1. angelas111

    angelas111 Jr. VIP Jr. VIP

    Joined:
    Jan 4, 2009
    Messages:
    1,598
    Likes Received:
    1,027
    Location:
    ohio
    I have a huge file and I need to copy all the data that exists between 2 specific strings of text. The data in between them is different in every instance and I need each instance copied into an excel file. I tried example1=(.*)&example2. and it grabs what i need starting after example1 but doesn't stop after example2 and grabs more data than what i need.

    If someone could help me with this today I will gladly pay you via paypal.

    pm me if you can do this. thanks
     
  2. angelas111

    angelas111 Jr. VIP Jr. VIP

    Joined:
    Jan 4, 2009
    Messages:
    1,598
    Likes Received:
    1,027
    Location:
    ohio
    update, my regex is working but now i'm not sure how to extract the matching data and copy it to another file. if anyone can help i will pay you asap. thanks
     
  3. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    7,309
    Likes Received:
    8,275
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    if you already figured out the search string you need to use, it's easy peasy from there just not with notepad++ :), because you can't export or copy the marked text to clipboard

    use SynWrite instead, open your file in it, under "Search" go to "Extract strings..." or just hit CTRL+E, paste your search string into the "Regular expression" field, hit "Find" then "Copy to clipboard", it will automatically remove the duplicate results, so you'll be left with only the unique ones one per line

    this is the regex you should use:
    HTML:
    (?<=the beginning of your string).*?(?=the end of your string)
    this will find everything what matches your string even if you have 2 or more matches in a single line
     
    • Thanks Thanks x 3
    Last edited: Sep 12, 2015
  4. amarindia

    amarindia Power Member

    Joined:
    Dec 5, 2014
    Messages:
    717
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Freelancer
    Location:
    India
    Hi,

    I can do it, please connect at skype: bpo2india to discuss further.
     
  5. angelas111

    angelas111 Jr. VIP Jr. VIP

    Joined:
    Jan 4, 2009
    Messages:
    1,598
    Likes Received:
    1,027
    Location:
    ohio
    Thank you so much!!! that worked like a charm. I was beating my head against the wall. :cool:
     
    • Thanks Thanks x 1
  6. trance92071

    trance92071 Senior Member

    Joined:
    Nov 1, 2009
    Messages:
    950
    Likes Received:
    849
    Occupation:
    Internet Marketing
    Location:
    BoosterBots.com
    Home Page:
    I can do this for you no problem, let me know if you still need help.