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

How to add a comma to a list of words

Discussion in 'Black Hat SEO' started by ibmethatswhoib, Oct 11, 2012.

  1. ibmethatswhoib

    ibmethatswhoib Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 17, 2011
    Messages:
    1,560
    Likes Received:
    1,156
    Occupation:
    Staying Informed
    Location:
    Bay Area, Ca
    Home Page:
    I have a list of 800 words like

    word one
    word two
    word three three
    blah blah

    How can I add a comma after those and turn it into.

    word one,word two,word three three,blah blah

    I have notepad ++ and some other tools just not really sure how to do it automatically, anyone?
     
  2. Webs2Be

    Webs2Be BANNED BANNED

    Joined:
    Oct 4, 2012
    Messages:
    198
    Likes Received:
    192
    Comma -> ,
     
  3. themidiman

    themidiman Power Member

    Joined:
    Feb 25, 2011
    Messages:
    701
    Likes Received:
    1,536
    Location:
    root@pts/0
    • Thanks Thanks x 3
  4. EXtraHand

    EXtraHand Junior Member

    Joined:
    Jan 26, 2012
    Messages:
    111
    Likes Received:
    62
    :) :)
     
  5. noman s

    noman s Registered Member

    Joined:
    Oct 5, 2012
    Messages:
    54
    Likes Received:
    7
    MS Excel has a formula which does that. Just search it on Google and you will find that formula.
     
  6. noman s

    noman s Registered Member

    Joined:
    Oct 5, 2012
    Messages:
    54
    Likes Received:
    7
    Ok, here it is..

    Here is a custom function that will do it.

    Alt + F11 to open the VB editor
    Select Insert/Module from the VB menu

    Paste the Text below in the new module window...

    Function MyMerge(Rng As Range)
    For Each Cell In Rng
    Temp = Temp & Cell.Value & ", "
    Next Cell
    Temp = Mid(Temp, 1, Len(Temp) - 2)
    MyMerge = Temp
    End Function

    Back in Excel, select the cell where you want the merged names to show up and add the formula =MyMerge(D1:D10). This is assuming the Names are in cells D1:D10. You can add whatever range you want. If you change any of the names in the range, the function will update the result.
     
    • Thanks Thanks x 1
  7. ibmethatswhoib

    ibmethatswhoib Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 17, 2011
    Messages:
    1,560
    Likes Received:
    1,156
    Occupation:
    Staying Informed
    Location:
    Bay Area, Ca
    Home Page:
    Sweet, thanks guys
     
  8. ChEcKeD

    ChEcKeD Senior Member

    Joined:
    Aug 27, 2012
    Messages:
    984
    Likes Received:
    467
    Occupation:
    ☺☺☺☺
    Location:
    ☺☺☺☺
    I use sortmylist.com , it's great
     
    • Thanks Thanks x 1
  9. SmartMan

    SmartMan BANNED BANNED

    Joined:
    Jul 25, 2012
    Messages:
    673
    Likes Received:
    1,244
    Here's a very easy tip/shortcut using notepad++ :

    Press Ctrl+F and go to Replace tab.
    Enter \r in Find what : Field
    Enter , in Replace with : Field
    Select Regular Expression under Search Mode.
    Press Replace All.
    Done.

    Hope you find it useful OP. :)
     
    • Thanks Thanks x 2
  10. twitter.followers

    twitter.followers Elite Member

    Joined:
    Mar 23, 2011
    Messages:
    1,768
    Likes Received:
    2,208
    Check this out: http://www.commaquote.com/
    You can even choose the separator you like whether its a comma or dot or anything else.
     
  11. Cas87

    Cas87 Regular Member

    Joined:
    Mar 5, 2012
    Messages:
    286
    Likes Received:
    131
    Location:
    England
    n/m can't use notepad++ that i know of
     
    Last edited: Oct 11, 2012
  12. proweb

    proweb Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    291
    Likes Received:
    144
    In Microsoft Word

    1) Hit Ctrl+H
    2) Find What: "^p" Replace with: ","
    3) Done
     
  13. DomePopping

    DomePopping Newbie

    Joined:
    Feb 2, 2011
    Messages:
    3
    Likes Received:
    0
    Use excel and copy and paste into excel and then type a comma and drag it down
     
  14. srb888

    srb888 Elite Member

    Joined:
    Jul 30, 2008
    Messages:
    3,260
    Likes Received:
    5,067
    Gender:
    Male
    Occupation:
    WebzSurfer
    Location:
    Sun, Mon, Tue, WTF, Sat!!! :)
    In Notepad++,

    1. place the cursor at the top of the list
    2. type ctrl+H to open the 'Replace' popup box
    3. In the 'Search Mode', the "Extended" should be selected
    4. In 'Find What' box: type \r\n
    5. In 'Replace With' box: type ,
    6. Click the Replace All button
    That's it!


    P.S.:
    I use TextPad for such tasks where Regular Expressions is concerned.

    In TextPad (the cursor can be anywhere) >>

    1. type Ctrl+H -- opens the 'Replace' box
    2. In the 'Conditions:', the "Regular expression" should be selected
    3. In 'Find What' box: type \n
    4. In 'Replace With' box: type ,
    5. Click the Replace All button
    That's it!





    HTH
     
    Last edited: Oct 12, 2012
  15. sockpuppet

    sockpuppet Junior Member

    Joined:
    Nov 7, 2011
    Messages:
    155
    Likes Received:
    145
    haha, that made me laugh
     
  16. ermiz

    ermiz Newbie

    Joined:
    Nov 11, 2007
    Messages:
    30
    Likes Received:
    10
    You can use ASAP Utilities, a free plugin for MS Excell. You can everything you want with this plugin and your list.
     
  17. dafaqq

    dafaqq Newbie

    Joined:
    May 18, 2012
    Messages:
    23
    Likes Received:
    3
    All of the above sound too complicated. here is the easiest fix

    1) Login to ur Gmail
    2) Click on Compose
    3) Paste all the words in the "TO" area(Where you type in the email address
    4) click anywhere else
    5) Done

    All the words will be followed by Commas :)
     
  18. judson

    judson Power Member

    Joined:
    Nov 29, 2009
    Messages:
    530
    Likes Received:
    319
    Occupation:
    Fulltime Newbie IM
    Location:
    Sub Ubi
    This thread is just killing me.

    Do folk seriously go go such lengths when a simple search and replace works just fine?
     
  19. SmartMan

    SmartMan BANNED BANNED

    Joined:
    Jul 25, 2012
    Messages:
    673
    Likes Received:
    1,244
    The steps posted by me and srb888 works the same.

    It takes the following format

    word one
    word two
    word three three
    blah blah

    and converts it into

    word one,word two,word three three,blah blah

    Notice how comma's are inserted in-between all those words and all words are shrunk into a single line instead of comma's added after all words on each 800 lines.

    Whereas the excel method converts it from

    word one
    word two
    word three three
    blah blah

    to

    word one___,
    word two___,
    word three three___,
    blah blah___,

    where ___ = Space aka blank space

    I don't think a simple search and replace will do the trick since there's nothing to replace but can be obtained only through regular expressions.
     
  20. DarkMeta

    DarkMeta BANNED BANNED

    Joined:
    Sep 27, 2012
    Messages:
    458
    Likes Received:
    80
    well thread is great new formulas i always do such work manual......lol