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

How can i separate a list with a space and comma?

Discussion in 'BlackHat Lounge' started by Hubert115, Jul 18, 2012.

  1. Hubert115

    Hubert115 Regular Member

    Joined:
    Jan 26, 2012
    Messages:
    488
    Likes Received:
    16
  2. partymarty4870

    partymarty4870 Elite Member

    Joined:
    Jul 7, 2010
    Messages:
    2,034
    Likes Received:
    1,690
    Location:
    I come from a land downunder
    I'd just use the replace function in notepad

    get it to replace ".com" with " ," (space comma)

    then repeat with all extensions (.net, .co.uk etc)

    Bit hard to see what you really want with that thin sliver of an example!
     
  3. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    If you do this ofter, you are better off getting the SoborSoft Extract Email from Text File. Then, you can save it as a list or as a comma.

    I know there are ways to do it with Excel but I have never learned since instead, I use the program above.
     
  4. Hubert115

    Hubert115 Regular Member

    Joined:
    Jan 26, 2012
    Messages:
    488
    Likes Received:
    16
    Thanks! I didn't even think of that :)
     
  5. partymarty4870

    partymarty4870 Elite Member

    Joined:
    Jul 7, 2010
    Messages:
    2,034
    Likes Received:
    1,690
    Location:
    I come from a land downunder
    there's a button for that
     
  6. JimmyConway

    JimmyConway BANNED BANNED

    Joined:
    Feb 12, 2010
    Messages:
    482
    Likes Received:
    227
    Consider using Microsoft Excel for storing lists. It's much more efficient than notepad.
     
    • Thanks Thanks x 1
  7. m0r0n

    m0r0n Registered Member

    Joined:
    Jun 13, 2011
    Messages:
    72
    Likes Received:
    55
    Occupation:
    {footprint}
    Location:
    {location|%k%w}
    notepad++ with textfx plugin
     
  8. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Tell him how and I'm sure he will.

    Question: How can I send a lot of email
    Answer: Try using a computer and you can send a lot.
     
  9. paulwilliams972

    paulwilliams972 Regular Member

    Joined:
    Apr 24, 2012
    Messages:
    370
    Likes Received:
    37
    Location:
    Tester World
    Ms Excel is better then notepad by using formula.
     
  10. JimmyConway

    JimmyConway BANNED BANNED

    Joined:
    Feb 12, 2010
    Messages:
    482
    Likes Received:
    227
    It really is not that hard to copy and paste something into excel and save it.

    Question: Why try and mock someone when they were just trying to help?
    Answer: Obviously, there is a lack of interesting things going on in that persons life.



     
  11. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Haha... Until I read your reply.

    How does the OP copying and pasting text into Excel do anything for him? In my example, that is equal to buying a computer and turning it on.

    If you are trying to help, the prove it. Paste step-by-step how to turn his list into what he needs.

    OP - Another suggestion is to download ASAP Utilities (its free). It's the most powerful plugin I have ever used for Excel. Select your data, select the Text menu (in ASAP Utilities) and click the first option 'Insert Before/After Each Selection' and in the After box, put a comma and space.

    Another, longer option is to paste your records in Excel, and create a new column and in it, only have a comma and space and merge them together. Then, copy that into a .html file and when you open it in a browser, it will all be in a continuous format as you requested.

    As you can see, there are multiple ways to do this. Some easier than others but some are more easy for a one-time operation. See what Jimmy says though.
     
  12. JimmyConway

    JimmyConway BANNED BANNED

    Joined:
    Feb 12, 2010
    Messages:
    482
    Likes Received:
    227
    I gave him a piece of advice regarding organization. A step by step guide you say? Would you like me to hold his hand as crosses the street as well? You saying "prove this", has little affect on the real world, man. You need to grow and stop attempting to get at people on a forum, it's pretty pathetic. OP, good luck with your data entry.
     
  13. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Maybe you didn't realize he said "How do I". Not "What program should I use".

    If you are going to walk your gf/wife to the car, you don't just walk to the door and stand there like an idiot - you either open and close the door or you don't offer to do anything. You had a chance to help and blew it as far as I'm concerned.

    BHW is a great community of people helping people and sometimes that means step-by-step. If he asked you how to market his site with SEO, I would not expect full details.

    As far as the real world goes, it does work as I said. You either put up or shut up! Simple as that.

    What is pathetic is when people respond to question with an answer that is of no use in helping them do what they need to do.
     
  14. jameshilton105

    jameshilton105 BANNED BANNED

    Joined:
    Feb 17, 2012
    Messages:
    215
    Likes Received:
    83
    Try Excel macros my friend...
     
  15. williamk

    williamk BANNED BANNED

    Joined:
    Oct 29, 2009
    Messages:
    1,030
    Likes Received:
    184
    If all else fails get a Outsourcer :D
     
  16. GauravJ

    GauravJ Power Member

    Joined:
    Jul 25, 2012
    Messages:
    626
    Likes Received:
    207
    Occupation:
    Internet Marketer
    Location:
    Near you
    Home Page:
    Hey if list is small
    You can use following formula
    =concatenate(cell1,","," ",cell2,","," ",...............cell n)

    Otherwise, use macros to work with with a big list