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

How to parse data on Excel?

Discussion in 'BlackHat Lounge' started by schrute, Mar 3, 2011.

  1. schrute

    schrute Regular Member

    Joined:
    Oct 14, 2010
    Messages:
    290
    Likes Received:
    16
    How to parse data on Excel?
    So I have an Excel sheet, I need to parse data between something in the columns..

    Basically, its like [madeupwebsite].com/linktosomewhere/{help}/33ksdjjd/somethingelse

    If I have a bunch of stuff like that, how can I parse the thing in pink?
     
  2. littlewebdragon

    littlewebdragon Jr. VIP Jr. VIP

    Joined:
    Dec 30, 2007
    Messages:
    875
    Likes Received:
    229
    Occupation:
    Occupation
    Location:
    Location
    Do you know how to do PHP? If you do, you can open up file, read every line of it using explode or list, then again, use explode of that line of yours and get your "pink" part of URL...

    Let me know if you need help I might be able to make this latter tonight for you in PHP as I will have some free time...
     
  3. schrute

    schrute Regular Member

    Joined:
    Oct 14, 2010
    Messages:
    290
    Likes Received:
    16
    Is it possible to do this in Excel? I have an .xls sheet with a list of these things. All I want to do is have a tab with just the pink part.

    I just need an explanation how its done.
     
  4. littlewebdragon

    littlewebdragon Jr. VIP Jr. VIP

    Joined:
    Dec 30, 2007
    Messages:
    875
    Likes Received:
    229
    Occupation:
    Occupation
    Location:
    Location
    Oh sorry I can't do that in Excel... :(
     
  5. blackjack

    blackjack Regular Member

    Joined:
    Nov 23, 2007
    Messages:
    276
    Likes Received:
    51
    if your pink link is after three of "/" then you can use Find function in Excel but if it different in each link then it will take longer to do using MID, LEFT, FIND etc functions.

    Other way to do is use Data>>>Text to Column>>>> which is make be more quick.

    Highlight the whole column, choose Data from Tool Bar, then click Text to Column, then check Delimited, press next next to box Other put "/" and then Finish. You should have three or four columns and one of them should have Pink Part

    If you want PM me your file and I can have a look.

    Thanks
     
    Last edited: Mar 3, 2011