If you want that for display purposes, use java.text.DecimalFormat: new DecimalFormat(“#.##”).format(dblVar); If you need it for calculations, use java.lang.Math: Math.floor(value * 100) / 100;
You can calculate the width of the string and see if the width is greater than label.bounds.size.width NSString UIKit Additions has several methods for computing the size of the string with a specific font. However, if you have a minimumFontSize for your label that allows the system to shrink the text down to that size. … Read more
You can use scala.math.BigDecimal: BigDecimal(1.23456789).setScale(2, BigDecimal.RoundingMode.HALF_UP).toDouble There are a number of other rounding modes, which unfortunately aren’t very well documented at present (although their Java equivalents are).
Using GNU sed: sed -i ‘$ d’ foo.txt The -i option does not exist in GNU sed versions older than 3.95, so you have to use it as a filter with a temporary file: cp foo.txt foo.txt.tmp sed ‘$ d’ foo.txt.tmp > foo.txt rm -f foo.txt.tmp Of course, in that case you could also use … Read more
FrustratedWithFormsDesigner is correct, PL/pgSQL can do this. Here’s the script: CREATE OR REPLACE FUNCTION truncate_tables(username IN VARCHAR) RETURNS void AS $$ DECLARE statements CURSOR FOR SELECT tablename FROM pg_tables WHERE tableowner = username AND schemaname=”public”; BEGIN FOR stmt IN statements LOOP EXECUTE ‘TRUNCATE TABLE ‘ || quote_ident(stmt.tablename) || ‘ CASCADE;’; END LOOP; END; $$ LANGUAGE … Read more
Update: text-overflow: ellipsis is now supported as of Firefox 7 (released September 27th 2011). Yay! My original answer follows as a historical record. Justin Maxwell has cross browser CSS solution. It does come with the downside however of not allowing the text to be selected in Firefox. Check out his guest post on Matt Snider’s … Read more
In management studio: Don’t do this on a live environment, but to ensure you shrink your dev db as much as you can: Right-click the database, choose Properties, then Options. Make sure “Recovery model” is set to “Simple”, not “Full” Click OK Right-click the database again, choose Tasks -> Shrink -> Files Change file type … Read more
Use the substring method: var length = 3; var myString = “ABCDEFG”; var myTruncatedString = myString.substring(0,length); // The value of myTruncatedString is “ABC” So in your case: var length = 3; // set to the number of characters you want to keep var pathname = document.referrer; var trimmedPathname = pathname.substring(0, Math.min(length,pathname.length)); document.getElementById(“foo”).innerHTML = “<a href=”” … Read more
Use cut. Eg. to strip the first 4 characters of each line (i.e. start on the 5th char): tail -f logfile | grep org.springframework | cut -c 5-
This continues to frequently gather additional votes, even several years later, and so I need to update it for modern versions of Sql Server. For Sql Server 2008 and later, it’s simple: cast(getDate() As Date) Note that the last three paragraphs near the bottom still apply, and you often need to take a step back … Read more