https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65070#M17731 Hello Team, I want to count repeated words from a MS word file. Please guide me how to do that. Sun, 22 Jul 2018 15:43:00 GMT NiteshMishra 2018-07-22T15:43:00Z https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65070#M17731 Hello Team, I want to count repeated words from a MS word file. Please guide me how to do that. Sun, 22 Jul 2018 15:43:00 GMT https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65070#M17731 NiteshMishra 2018-07-22T15:43:00Z https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65071#M17732 Hi Nitesh. I created a process using ""utility - Strings"" - split text action and ""utility - Collection Manipulation"" VBO's to count distinctive terms from text. I modified the ""MS Word VBO"" - Copy to Clipboard action code to include this code: ""output = Len(s.text)"", so that I can use the ""Get Body action from the MS Word VBO, that requires the start and finish (characters). This is only a suggestion as to how you can grab text from word, there are probably more than one way to do this. See enclosed file for my take on how to count repeated words and how to grab text from a word document. Good luck. BR, Mustafa Tue, 24 Jul 2018 14:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65071#M17732 Mustafa_UlasYig 2018-07-24T14:03:00Z https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65072#M17733 Many Thanks Sir for the suggestion, I will try using your solution. Wed, 25 Jul 2018 15:32:00 GMT https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65072#M17733 NiteshMishra 2018-07-25T15:32:00Z https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65073#M17734 No problem sir. Here is an updated version, as it fails, when you do not remove line-feeds from the text. This version removes line-feeds, hyphens, commas and punctuation, you can choose to remove the others, just not the removal of line-feeds. It is way fast(er) when you run the process from the control room. But that said, this could probably be (a bit) faster when and if you wrote some vbnet/c# code instead. See updated version attached. Good luck :) BR, Mustafa Wed, 25 Jul 2018 18:13:00 GMT https://community.blueprism.com/t5/Product-Forum/Want-to-count-repeated-words-from-a-MS-word-file/m-p/65073#M17734 Mustafa_UlasYig 2018-07-25T18:13:00Z