Results 1 to 2 of 2
  1. #1
    Full Member jazzylee77's Avatar
    Join Date
    February 19th, 2005
    Posts
    199
    Finding repeating phrases
    Any tips on this?

    I can usually spot a few repeating phrases in columns of a datafeed and come up with subsititutions. But I was thinking..."It sure would be nice if there was a tool that would find repeating phrases (I suppose I should call them strings) and then ideally list them according to length and/or number of repetitions."

  2. #2
    Full Member jazzylee77's Avatar
    Join Date
    February 19th, 2005
    Posts
    199
    I found one thing that is helpful.

    to find duplicate and unique content in a column
    Code:
    =IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","Unique")
    I guess not amazing news to those who routinely use such statements. now if I change it to
    Code:
    =IF(COUNTIF($A$2:A2,A2)>5,"Many","Few")
    I can filter the results for cells that are repeated more than 5 times. So I'm getting closer. Now if I can figure how to tweak it to count similar strings within cells. (or luck out and have someone spoon feed it to me..)

  3. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Strange repeating pattern in sales
    By roboseller in forum Commission Junction - CJ
    Replies: 0
    Last Post: January 9th, 2006, 11:02 AM
  2. Php Mysql - Repeating..??
    By AddHandler in forum Programming / Datafeeds / Tools
    Replies: 13
    Last Post: May 7th, 2005, 03:25 PM
  3. Using data from another table in a repeating recordset?
    By Taurus in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: January 1st, 2003, 08:07 PM
  4. Using phrases in keywords?
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: July 19th, 2002, 10:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •