Spliting paragraph into sentences and attach in

Posted on 16th Feb 2014 by admin

Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2[abc?defghij.klmnop! etc] 3+ sentences

It should split the paras into sentences based on delimiters (.?!), count the length of characters in those sentences.

If any sentence more than "120" charaters it should attach "..." at the end of sentence.

Then email the sentences in an excel(attached)
example.xls

123.
456.
789!
abc?
defghij.
klmnop!
dskasdjkasjkdjfkdgjkfgjflhkglfhkdljsakfjdkf...

Please send me sample code, please don't just tell me I can use explode() function or split....etc

Other forums