1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Is it possible

Discussion in 'MySQL' started by kool002, May 20, 2007.

  1. #1
    Can someone write a script which will read my articles and create a file which has all the words in that article.

    for example
    say article is.

    There is a new gadget by abc company with great features like auto reset....

    I want a file or a table popuplated with words like
    There
    is
    a
    new
    gadget...etc etc

    ... well you get the idea.
     
    kool002, May 20, 2007 IP
  2. zonzon

    zonzon Peon

    Messages:
    100
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    hum, wich language? you can use the split function of your favorite language...

    example :
    in perl : @array = split('**separator**', $string);

    **separator** can be a single character or a regular expression, in your case I would prefer the regexp \s{1,} that catches every single or multiple spaces...

    i dont know your specific needs, but look at FULLTEXT SEARCH of MySQL is also great...
     
    zonzon, May 20, 2007 IP
  3. teachai

    teachai Peon

    Messages:
    9
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If you're using Oracle then this is done for you. You use Oracle Text, but I suspect you're not using Oracle
     
    teachai, May 25, 2007 IP
  4. raredev

    raredev Peon

    Messages:
    49
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    it's a simple one/two hour script either using file or table.
    just read input split (using explode function in php) and produce the result.
    but i'm just too lazy working on this for free :p
    you should ask on programming thread, not here :)
     
    raredev, May 25, 2007 IP
  5. carolynheath

    carolynheath Peon

    Messages:
    680
    Likes Received:
    63
    Best Answers:
    0
    Trophy Points:
    0
    #5
    sure it's possible, that's what explode() split()
    and the like are for

    tell us the language :D
     
    carolynheath, May 31, 2007 IP
  6. mjesales

    mjesales Peon

    Messages:
    326
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #6
    you can do it in editpad lite - just find all " " (space) and replace with a line break... then save it as a csv - open it in excel - and filter out the dupes.
     
    mjesales, Jun 6, 2007 IP
  7. raredev

    raredev Peon

    Messages:
    49
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    i think he wan't it automatically :D
     
    raredev, Jun 7, 2007 IP
  8. ansi

    ansi Well-Known Member

    Messages:
    1,483
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    100
    #8
    i hope an hour and 45 minutes of that two hours is just sitting there twiddling your nipples. this shouldn't take longer than 10 minutes. in any language...
     
    ansi, Jun 7, 2007 IP
  9. kashif.nazar

    kashif.nazar Peon

    Messages:
    52
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    I can tell you the steps , do it urself
    1. Just parse the string on the basis of space, when ever u find the space,
    means a word gets, and save it in a veriable.
    2. Make a connection with the data base, or open a text file.
    3. Write it in the file or database.
     
    kashif.nazar, Jun 9, 2007 IP