17 {{ upvoteCount | shortNum }}
17 {{ upvoteCount | shortNum }}

[Solved] Is there any chance to turn return into comma the fastest way?

by Raja Kamil
14 replies
Hi;
I know warriors is the place where value time very much.
When doing work, they put productivity in front of everything.

My question is about increase productivity or effectiveness.

Let say, I have this bunch of keyword

keyword1
keyword2
keyword3

is there any fast way to turn the list above into keyword1, keyword2, keyword3 ?

If it just involve 20 or less keywords, it doesn't matter, but there a half million of keywords.

Please help me, I am doing some testing.

Thanks in advance.


UPDATE :

Thank you for all the replies. My problem solved. I hope moderator would leave this thread live so that when anybody have same problem like me, they can find the solution here.

Anyway, here are three solutions that I think work the best.

The first one is provided by Snapcontent.
Click here for his solution :
http://www.warriorforum.com/main-int...ml#post2630904

Solution using microsoft word, replace and find tool (Ctrl+F) and type ^13 in Find box and in replace box type ,


Another solution provided by Warriorkay
Here the post,
http://www.warriorforum.com/main-int...ml#post2630855

Using a free software. I don't try it yet.

The best one.
Using Market Samurai (paid version)

http://www.warriorforum.com/main-int...ml#post2630854

PS : Of course I'm biased :p

Anyway, to you in future, if you find none of the methods above work, PM me, we will find latest way to solve this problems.


Raja Kamil
#chance #comma #fastest #return #turn
  • Profile picture of the author Alfred Shelver
    If you have excel you can copy the keywords and then 'Paste special' - 'transpose' and save the file as a CSV (comma separated value file). Thats off the top of my head I am sure there is an easier way in excel as well.

    But without excel I cannot see you doing this.
    Signature
    Best $10 Articles on Warrior Forum Guaranteed
    {{ DiscussionBoard.errors[2630695].message }}
    • Profile picture of the author Raja Kamil
      Originally Posted by Cathy Shelver View Post

      If you have excel you can copy the keywords and then 'Paste special' - 'transpose' and save the file as a CSV (comma separated value file). Thats off the top of my head I am sure there is an easier way in excel as well.

      But without excel I cannot see you doing this.
      Thanks Cathy, I'm trying right now.
      {{ DiscussionBoard.errors[2630698].message }}
  • Profile picture of the author Will Edwards
    I think you can do a search & replace in Word - there is a 'Special Characters' option for this type of thing, as I recall.

    Will
    {{ DiscussionBoard.errors[2630728].message }}
    • Profile picture of the author Raja Kamil
      Originally Posted by Cathy Shelver View Post

      If you have excel you can copy the keywords and then 'Paste special' - 'transpose' and save the file as a CSV (comma separated value file). Thats off the top of my head I am sure there is an easier way in excel as well.

      But without excel I cannot see you doing this.
      Originally Posted by Will Edwards View Post

      I think you can do a search & replace in Word - there is a 'Special Characters' option for this type of thing, as I recall.

      Will
      Argh.. no success.
      I manage to get the list become,

      keyword1,
      keyword2,
      keyword3,

      but can't move on to

      keyword1, keyword2, keyword3,
      {{ DiscussionBoard.errors[2630732].message }}
      • Profile picture of the author AprilCT
        Not sure if I am getting what you want, but couldn't you do a control F, find and replace the paragraph symbol with a space?

        If you have 500,000 keywords, you better try this a few at a time. Word tends to get choked up and sometimes lose your document if you ask it to do too much at one time.

        Once you get your words on a document, copy over sections at a time to a new document to fix, so you don't worry about any problems or slowdowns.
        {{ DiscussionBoard.errors[2630815].message }}
        • Profile picture of the author Raja Kamil
          Originally Posted by AprilCT View Post

          Not sure if I am getting what you want, but couldn't you do a control F, find and replace the paragraph symbol with a space?
          I've thought about it but don't know the paragraph symbols
          {{ DiscussionBoard.errors[2630820].message }}
  • Profile picture of the author Raja Kamil
    I've found the solution.

    I used Market Samurai keyword research.


    Thanks everybody who are helping me a lot.

    Raja Kamil
    {{ DiscussionBoard.errors[2630854].message }}
    • Profile picture of the author warriorkay
      Originally Posted by Raja Kamil View Post

      I've found the solution.

      I used Market Samurai keyword research.


      Thanks everybody who are helping me a lot.

      Raja Kamil

      Oops, I typed my solution in just 1 second
      before you found yours,

      Kingsley
      Signature
      Kingged.com Coaching and Partnership Program
      Is The ONLY Coaching Program That Does 99% Of The Work
      TO MAKE MONEY FOR STUDENTS FROM 1ST DAY
      So they EARN while they LEARN
      {{ DiscussionBoard.errors[2630859].message }}
      • Profile picture of the author Raja Kamil
        Originally Posted by warriorkay View Post

        Oops, I typed my solution in just 1 second
        before you found yours,

        Kingsley
        No problem. There may be people have this problem but don't have MS.
        Your solution using free software and it is better.
        {{ DiscussionBoard.errors[2630864].message }}
  • Profile picture of the author warriorkay
    Sure.

    Download Textpad.com (it's free).

    Load your keywords into it. Select
    the find and replace feature.

    For the find, type in "\n" (that's end of line sign)
    For the replace, type in ", " (that's comma and space).
    Hit enter, and watch the magic happen,

    I use it all the time,

    Kingsley
    Signature
    Kingged.com Coaching and Partnership Program
    Is The ONLY Coaching Program That Does 99% Of The Work
    TO MAKE MONEY FOR STUDENTS FROM 1ST DAY
    So they EARN while they LEARN
    {{ DiscussionBoard.errors[2630855].message }}
  • Profile picture of the author snapcontent
    You used to be able to do it in word - I believe the character to replace was ^13
    {{ DiscussionBoard.errors[2630904].message }}
    • Profile picture of the author Paul Myers
      In many text editors, you can do it using the find and replace option, and using ^P in the find, and a comma in the replace field.

      I haven't used the /n option suggested earlier, but I know this one works with any Windows-based text editor I've used.


      Paul
      Signature
      .
      Stop by Paul's Pub - my little hangout on Facebook.

      {{ DiscussionBoard.errors[2630958].message }}
      • Profile picture of the author Raja Kamil
        Originally Posted by Paul Myers View Post

        In many text editors, you can do it using the find and replace option, and using ^P in the find, and a comma in the replace field.

        I haven't used the /n option suggested earlier, but I know this one works with any Windows-based text editor I've used.


        Paul
        Paul, thanks for reply. Unfortunately ^P not working but ^13 will work.

        Thanks to snapcontent

        Originally Posted by snapcontent View Post

        You used to be able to do it in word - I believe the character to replace was ^13
        {{ DiscussionBoard.errors[2630976].message }}
        • Profile picture of the author snapcontent
          Originally Posted by Raja Kamil View Post

          Paul, thanks for reply. Unfortunately ^P not working but ^13 will work.

          Thanks to snapcontent
          You're welcome.

          If you're going to do it a lot, you might want to knock up a script to do it. In PHP, you'd try and replace \r\n then try \r then try \n
          {{ DiscussionBoard.errors[2636392].message }}

Trending Topics