I have been trying to do some work in excel, but i seem to be stuck on one point
in colum "A" i have: a, b, c, d, e
in colum "B" i have: done, started, completed
in colum "C" to colum "S" i have: some "X"'s but not in all fields.
So my question is how do i do the following
foreach row in excel.A
Where Bx is done
count("X", $row)
I have tried pivot, countif, sumproduct but i cant seem to get it to work, any ideas?
I have a large Exchange server with many hundreds of thousands of emails in thousands of folders.
I would like to generate a list of how many emails have been sent, by user, for a subset of the public folders.
If I could run SQL against the server (can I?), I would like to run a query along the lines of:
SELECT from, count(*)
FROM emails
WHERE email_is_in_folder_or_descendents('Public Folders/Customers/XYZ')
GROUP BY from
Is this possible?
I have full administrator access to the server.
Open Word and insert a table (1 x 1 will work just fine).
Right-click in the table and, in the context menu, select "Bullets" and a bullet image from the bullet library.
Type something and press enter.
Type something else, but, instead of clicking enter, right-click and select "Increase Indent"
Notice something else moves into the proper indentation of a nested bullet:
Outside of a Word table, you would simply press tab to get this behavior, but I want a keyboard shortcut (if available) to do this inside the table.
This is what I've tried:
Ctrl + Tab: Just indents the text, not the bullet
Ctrl + T: Same as Ctrl + Tab
Ctrl + M: Indents the text and the bullet but does not change the
bullet style
Can this be done outside the right-click context menu?
Hi Folks,
I am beginner to scripting and vigorously learning TCL for the development of embedded system.
I have to Search for the files with only .txt format in the current directory, count the number of cases of each different "Interface # nnnn" string in .txt file, where nnnn is a four or 32 digits max hexadecimal no and o/p of a table of Interface number against occurrence. I am facing implementation issues while writing a script i.e, Unable to implement the data structure like Linked List, Two Dimensional array.
I am rewriting a script using multi dimension array (Pass values into the arrays in and out of procedure) in TCL to scan through the every .txt file and search for the the string/regular expression ‘Interface # ’ to count and display the number of occurrences. If someone could help me to complete this part will be much appreciated.
Search for only .txt extension files and obtain the size of the file
Here is my piece of code for searching a .txt file in present directory
set files [glob *.txt]
if { [llength $files] > 0 } {
puts "Files:"
foreach f [lsort $files] {
puts " [file size $f] - $f"
}
} else {
puts "(no files)"
}
I reckon these are all the possible logical steps behind to complete it
i) Once searched and find the .txt file then open all .txt files in read only mode
ii) Create a array or list using the procedure (proc) Interface number to NULL and Interface count to zero 0
iii) Scan thro the .txt file and search for the string or regular expression "interface #
iv) When a match found in .txt file, check the Interface Number and increment the count for the corresponding entry. Else add new element to the Interface Number list
v) If there are no files return to the first directory
My o/p is like follows
Interface Frequency
123f 3
1232
4
I tested this code in Chrome and there seems to be a bug involving the newlines. I am reaching the maxlength before I actually use all the characters.
<textarea id="myText" maxlength="200" style="width:70%;height:200px">
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s...
Enter something:
</textarea>
<div>
Char Count <span id="count"></span>/<span id="max"></span>
</div>?
<script>
var ta = document.getElementById('myText');
document.getElementById('max').innerHTML = ta.maxLength;
setInterval(function() {
document.getElementById('count').innerHTML = ta.value.length;
}, 250);?
</script>
How can I accurately get the char count of a textarea?
jsFiddle demo: http://jsfiddle.net/Qw6vz/1/
Hi,
We're using Crystal Reports.NET that was bundled with VS2005. We have a confirmation booking form letter report that we want to batch print. Generally this prints one page per person on letterhead paper, however occasionally if they've booked lots of courses the letter rolls over to two pages. The second page should not be printed to letterhead paper.
Basically, because it's a rare occurance I was just going to print the lot and pause if a particular letter went over 1 page. I.e. Load the report, grab the page count, hollah at the user if it's more than one page otherwise carry on regardless.
I have dropped a TotalPageCount on the footer of my report (Which I would supress if it worked!) and then try and read it in my application.
Once I've loaded the document I am trying to call
report.ReportDefinition.ReportObjects("TotalPageCount1")
Which is of type CrystalDecisions.CrystalReports.Engine.FieldObject
I cannot seem to get the value out of this for love nor money (nor any amount of cursing and swearing!)
I can read any items of type TextObject, but if I append the TotalPageCount to a text field, it shows correctly in the report but then returns "Page count: TotalPageCount" rather than "Page count: 1" for example.
Soo, short of going out of my mind, does anyone have any suggestions? Either a way to read the value or a way round it. The printer doesn't have multiple trays, though even if we got one, I'm not sure how to convince crystal to print different pages to different trays.
Best regards,
Stuart
P.S. - is it a sign that the "crystal-reports" tag has a count of 666? :O(
I have two tables:
**Product**
ID
Name
SKU
**Brand**
ID
Name
Product table has about 120K records
Brand table has 30K records
I need to find count of all the products with name and brand matching a specific keyword.
I use freetext 'contains' like this:
SELECT count(*)
FROM Product
inner join Brand
on Product.BrandID = Brand.ID
WHERE (contains(Product.Name, 'pants')
or
contains(Brand.Name, 'pants'))
This query takes about 17 secs.
I rebuilt the FreeText index before running this query.
If I only check for Product.Name. They query is less then 1 sec. Same, if I only check the Brand.Name. The issue occurs if I use OR condition.
If I switch query to use LIKE:
SELECT count(*)
FROM Product
inner join Brand
on Product.BrandID = Brand.ID
WHERE Product.Name LIKE '%pants%'
or
Brand.Name LIKE '%pants%'
It takes 1 secs.
I read on MSDN that: http://msdn.microsoft.com/en-us/library/ms187787.aspx
To search on multiple tables, use a
joined table in your FROM clause to
search on a result set that is the
product of two or more tables.
So I added an INNER JOINED table to FROM:
SELECT count(*)
FROM (select Product.Name ProductName, Product.SKU ProductSKU, Brand.Name as BrandName FROM Product
inner join Brand
on product.BrandID = Brand.ID) as TempTable
WHERE
contains(TempTable.ProductName, 'pants')
or
contains(TempTable.BrandName, 'pants')
This results in error:
Cannot use a CONTAINS or FREETEXT predicate on column 'ProductName' because it is not full-text indexed.
So the question is - why OR condition could be causing such as slow query?
I have to get certain count from files. The grep statement i am using is like this :
counter_pstn=0
completed_count_pstn=0
rec=0
for rec in `(grep "merged" update_completed*.log | awk '{print $1}' | sed 's/ //g' | cut -d':' -f2)`
do
if [ $counter_pstn -eq 0 ]
then
completed_count_pstn=$rec
else
completed_count_pstn=$(($completed_count_pstn+$rec))
fi
counter_pstn=$(($counter_pstn+1))
done
echo "Completed Orders PSTN Primary " $completed_count_pstn
But the log file contains data in this format :
2500 rows merged.
2500 rows merged.
2500 rows merged.
2500 rows merged.2500 rows merged.
2500 rows merged.
2500 rows merged.
As a result , it is missing out the count of one merge(eg on line 4 of output).How do i modify the grep or use another function to get the count. NOTE that the 2500 number maybe for different logs. So we have to use "rows merged" pattern to get the count. i have tried -o ,-w grep options,but it is not working.
Expected output from above data:
17500
Actual output showing :
15000
It looks like the DSOFramer.ocx component is not available for download anymore from MSDN as described here. Also the DSOFramer component is a 32 bit component. Given this, i have 2 questions:
Is there any other alternative for hosting a word document in a Windows Form apart from using the DSOFramer.ocx component?
If i move to Windows 64 bit operating system, and run the windows form as a native 64 bit process, then how do I host the word document in a 64 bit process?
Hii..
Can anybody help me to find an algorithm in Java code to find synonyms of a search word based on the context and I want to implement the algorithm with WordNet database.
For example, "I am running a Java program". From the context, I want to find the synonyms for the word "running", but the synonyms must be suitable according to a context.
Hey, Im a newbie in cocoa and I have a string and I am trying to count how long it is. I have been searching through Apples docs but I can't find anything.
NSString *word = @"word";
How would I figure out how many characters is in a string?
Thanks
I need to use the Microsoft.Office.Interop.Word namespace to extract if a Word document contains macros, and which ones. The MSDN documentation for this namespace doesn't give much information compared to the documentation on other .Net classes.
Where can I get more informations about this namespaces (examples, complete documentation, etc.). I already searched on Google and SO but didn't much information.
I've always wondered where did the word "Polymorphism" word come from. I know what is polymorphism and I use it of course, but I just don't understand why this technique called polymorphism.
Note that I'm not a native English speaker, and I will thank you if you'll use simple English in your answers.
Thank you.
I want to write a regular expression that will replace the word Paris by a link, for only the word is not ready a part of a link.
Example:
i'm living <a href="Paris" atl="Paris link">in Paris</a>, near Paris <a href="gare">Gare du Nord</a>, i love Paris.
would become
i'm living.........near <a href="">Paris</a>..........i love <a href="">Paris</a>.
Hi there,
I have a template in word (.docx) format and want to replace some placeholders in this template with my own data, do you know where I can find the right classes for this project? It would be nice for me to know the namespace. Are there any newer classes for handling word documents in the docx format (xml) than the com classes? Thank you for all your answers, I hope someone can help me with my problem.
greets
Sebastian
What's the best way of converting PDF docs to Microsoft Word format in PHP? This can be either as a PHP script or calling a (Linux) executable (with proc_open()). It just needs to be relatively fast and produce quality Word documents (in 97/2000/2003 format).
Commercial software is OK.
Is there a way to export a wiki page to a MS word document in WSS? Ideally, I would like to add a link on every WIKI page when clicked would export the content to a Word document. Any free plugins to do this?
Hi there
I'm lookin for a javascript plugin (for js/any framework)
I want to create a textarea that while I type will using a supplied data array, check for predictive matches to the current word im typing and try to suggest a solution.
All solutions I've found so far (for jquery) only match one word, then end...
I want to write like a sentence or paragraph but have autocomplete ability.
Mockup image attached.
there is one linkbtn , on click i have to display word document content inside any textBox which supports, i used simple textbox but am facing the formatting problem. and also it does not show image. there is any idea for problem in display word document content inside any textBox .
i dont know about richtextbox, can i get any help, please send me desired code to [email protected]
Hi,
I'm trying to shorten a wordpress title to just the first word. For a page named "John Doe" I want to have a sub title somewhere on the page that says "About John" so I want to just get the first word from the title.
Is there a way to do this with PHP?
Thanks!
I observed that size of long is always equal to the WORD size of any given CPU architecture. Is it true for all architectures? I am looking for a portable way to represent a WORD sized variable in C.
I am looking for a open source library in Java for HTML Microsoft Word conversion. I have found many tools for Word to HTML conversion but not too many for converse.
how to write contents in a word doc or pdf in c#
like if i want to write some daily reports generated into word doc or pdf ..in unix we can just pipe the out put to text file can we do that in c# .i know that using string builder we can write the contents to text files can we write the contents to a doc or pdf format ?