Page 1 of 2 12 LastLast
Results 1 to 13 of 15

Thread: OT: need some Excel or Word help

  1. #1


    Did you find this post helpful? Yes | No

    OT: need some Excel or Word help

    This has nothing to do with BJ, but need a little help from someone with Excel and/or MSWord experience.

    I have several txt files with a list of "words" (mixed numbers/letters), one per line.
    I want to import several of these txt files into Excel (or Word) and do a compare to find the "words" that are common to more than one file.
    Can someone tell me if this is possible, and if so, how to do it?
    Thanks.

  2. #2


    Did you find this post helpful? Yes | No
    It can be done. I would import into Excel. The first question is wheather the combo word numbers are all put into 1 column, or do you want to compare over several columns. The second is, do you want to compare the entire word number, or just the word. The third question is the letter number order. Are the numbers interspersed with the letters, or is it a constant word number or number word pattern.

    The overall size of the file will determine wheather you can do this with formulas, or a VB macro.

    Scenario
    Put everything into 1 column. If 1 pattern, parse, then run another column searching for duplicates. If interspersed, then run a column extracting letters only, then run another column checking for duplicates.

    I used to do a lot of 5hat stuff, but im a bit rusty now, but this get you on the right track.

  3. #3


    Did you find this post helpful? Yes | No
    Quote Originally Posted by 21forme View Post
    This has nothing to do with BJ, but need a little help from someone with Excel and/or MSWord experience.

    I have several txt files with a list of "words" (mixed numbers/letters), one per line.
    I want to import several of these txt files into Excel (or Word) and do a compare to find the "words" that are common to more than one file.
    Can someone tell me if this is possible, and if so, how to do it?
    Thanks.
    I do something like this with my excel blackjack spreadsheet. I use a "If, Then Formula." My first column shows how much I won or lost on any given day. My second column shows the casino name I played at. I want to break out one casino from the rest which I will call "CasinoA." Then the formula I put in the third column becomes =IF(B2="CASINOA",A2,0)

    So if you have a list of words and you are looking to pull out all words called CASINOA from the list then just use an "If, Then Formula."

  4. #4


    Did you find this post helpful? Yes | No
    Thanks for the response, Freightman.

    Each "word" is of varying length (usually 4-8 characters) and has a mix of letters and numbers. It all can be put into one column. Each list has about 200-250 "words." I just want to identify the repeats from list to list. if you want to take this off-list and email me, feel free.

  5. #5
    Senior Member
    Join Date
    Sep 2013
    Location
    yep...want my phone #, too?
    Posts
    949


    Did you find this post helpful? Yes | No
    Quote Originally Posted by 21forme View Post
    ..I have several txt files with a list of "words" (mixed numbers/letters)...
    MS Word, Review, Compare....(check options)

  6. #6


    Did you find this post helpful? Yes | No
    Quote Originally Posted by Sharky View Post
    MS Word, Review, Compare....(check options)
    Sharky - what I want to do is the opposite of this. I want to find words that are the same (and not necessarily in the same place in the document), not differences. Am I missing something?

  7. #7
    Senior Member
    Join Date
    Sep 2013
    Location
    yep...want my phone #, too?
    Posts
    949


    Did you find this post helpful? Yes | No
    Quote Originally Posted by 21forme View Post
    Sharky - what I want to do is the opposite of this. I want to find words that are the same (and not necessarily in the same place in the document), not differences. Am I missing something?
    Try combing the docs ...should highlight the differences

    Otherwise, write a relatively simple VBA routine that reads every word on one doc and writes to a file...then just loop through that file and calculate the number of "hits"

    Hope that helps

  8. #8


    Did you find this post helpful? Yes | No
    Quote Originally Posted by 21forme View Post
    Thanks for the response, Freightman.

    Each "word" is of varying length (usually 4-8 characters) and has a mix of letters and numbers. It all can be put into one column. Each list has about 200-250 "words." I just want to identify the repeats from list to list. if you want to take this off-list and email me, feel free.
    So, if I understand correctly, the “words” include the numbers, and that You want to find out how many times that *****12 appear, and how many times *****13 appear, not fuzzy matching *****12 and *****13, extracting the numbers and searching for ***** only, not that there’s anything wrong with that.

    So, without altering the order of the alphanumeric characters, dump every text file (you don’t have to, just makes it easier), into column a, starting at A1, and making 1 long column. Then, in column b, starting at b1, the formula (I’ll test it later once I go to my basement office - it has been so long, im sure it’s off)

    =if(countif,a:a>1,1)

    This should list the number of occurrences of every unique alphanumeric. Single occurrences will display as 1, duplicate occurrences as 2, triples at 3 etc.

    If this is what you’re looking for, let me know, and I will test and correct the formula.

  9. #9


    Did you find this post helpful? Yes | No
    Quote Originally Posted by Freightman View Post
    So, if I understand correctly, the “words” include the numbers, and that You want to find out how many times that *****12 appear, and how many times *****13 appear, not fuzzy matching *****12 and *****13, extracting the numbers and searching for ***** only, not that there’s anything wrong with that.

    So, without altering the order of the alphanumeric characters, dump every text file (you don’t have to, just makes it easier), into column a, starting at A1, and making 1 long column. Then, in column b, starting at b1, the formula (I’ll test it later once I go to my basement office - it has been so long, im sure it’s off)

    =if(countif,a:a>1,1)

    This should list the number of occurrences of every unique alphanumeric. Single occurrences will display as 1, duplicate occurrences as 2, triples at 3 etc.

    If this is what you’re looking for, let me know, and I will test and correct the formula.
    Hmmm, looks like the program asterisked P u s s y.

  10. #10


    Did you find this post helpful? Yes | No
    It's not the count I'm looking for. I want to produce a list of the words that appear more than once.

  11. #11


    Did you find this post helpful? Yes | No
    Quote Originally Posted by 21forme View Post
    It's not the count I'm looking for. I want to produce a list of the words that appear more than once.
    Then, the answer is very close, and I’ll fool around with it after dinner - 2 or 3 hours. Something like starting at B1

    =if(a:a,A1>1,A1)

    And then filter out the duplicate words.

  12. #12


    Did you find this post helpful? Yes | No
    Can be done but too complex to provide answer here.

    While using excel formulas may work, I expect them to be very cumbersome for this type of parsing.

    May be easier to write VBA code after importing into an excel sheet.

    PM me if you want more help.
    Luck is nothing more than probability taken personally!

  13. #13


    Did you find this post helpful? Yes | No
    Quote Originally Posted by Stealth View Post
    Can be done but too complex to provide answer here.

    While using excel formulas may work, I expect them to be very cumbersome for this type of parsing.

    May be easier to write VBA code after importing into an excel sheet.

    PM me if you want more help.
    If I read correctly, does not need to be parsed. The “words” are a combination of letters and numbers, and do not need to be resorted. The duplicated words can easily be extracted by formula.

    If the file was super huge, then VBA would be the way to go.

Page 1 of 2 12 LastLast

Similar Threads

  1. jblaze: excel gaussian dist.
    By jblaze in forum Computing for Counters
    Replies: 2
    Last Post: 01-18-2006, 01:27 PM
  2. nycfudu: trackjack on excel?
    By nycfudu in forum Main Forum
    Replies: 1
    Last Post: 04-16-2005, 10:08 PM
  3. Wildcard: MS 2k Excel formula ?
    By Wildcard in forum Computing for Counters
    Replies: 5
    Last Post: 02-14-2005, 05:48 AM
  4. Sonny: Trying to find Trip ROR in Excel
    By Sonny in forum Computing for Counters
    Replies: 3
    Last Post: 04-17-2004, 09:41 PM
  5. Sun Runner: Excel question -No BJ
    By Sun Runner in forum Computing for Counters
    Replies: 6
    Last Post: 03-09-2004, 05:43 AM

Bookmarks

Posting Permissions

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

About Blackjack: The Forum

BJTF is an advantage player site based on the principles of comity. That is, civil and considerate behavior for the mutual benefit of all involved. The goal of advantage play is the legal extraction of funds from gaming establishments by gaining a mathematic advantage and developing the skills required to use that advantage. To maximize our success, it is important to understand that we are all on the same side. Personal conflicts simply get in the way of our goals.