The Groovy community has added a take() method which can be used for easy and safe string truncation. Examples: “abscd adfa dasfds ghisgirs fsdfgf”.take(10) //”abscd adfa” “It’s groovy, man”.take(4) //”It’s” “It’s groovy, man”.take(10000) //”It’s groovy, man” (no exception thrown) There’s also a corresponding drop() method: “It’s groovy, man”.drop(15) //”n” “It’s groovy, man”.drop(5).take(6) //”groovy” Both take() … Read more
System.Uri is your friend here. This has many helpful utilities on it, but the one you want is GetLeftPart: string url = “http://www.website.com/default.aspx?utm_source=twitter&utm_medium=social-media”; Uri uri = new Uri(url); Console.WriteLine(uri.GetLeftPart(UriPartial.Path)); This gives the output: http://www.website.com/default.aspx [The Uri class does require the protocol, http://, to be specified] GetLeftPart basicallys says “get the left part of the uri … Read more
Works here: http://jsfiddle.net/TReRs/4/ .overme { width: 300px; overflow:hidden; white-space:nowrap; text-overflow: ellipsis; color: red; } <div class=”overme”> how much wood can a woodchuck chuck if a woodchuck could chuck wood? </div> Trailing dots/ellipsis are colored in red using that basic CSS.
The accepted answer only works if you need to recreate the whole database. To drop a single table (with the callbacks) and to get the IDs to start from 1: Model.destroy_all # Only necessary if you want to trigger callbacks. ActiveRecord::Base.connection.execute(“TRUNCATE #{table_name} RESTART IDENTITY”) If you are using Sqlite, it does not support truncate so … Read more
Doubles don’t have decimal places – they’re not based on decimal digits to start with. You could get “the closest double to the current value when truncated to three decimal digits”, but it still wouldn’t be exactly the same. You’d be better off using decimal. Having said that, if it’s only the way that rounding … Read more
If you want to preserve the previous contents of the file up to some length (a length bigger than zero, which other answers provide), then POSIX provides the truncate() and ftruncate() functions for the job. #include <unistd.h> int ftruncate(int fildes, off_t length); int truncate(const char *path, off_t length); The name indicates the primary purpose – … Read more
As I already wrote in an earlier comment, the MySQL manual says: Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 65,535. So the problem is not with the data type of the field. The MySQL manual also says: The result is truncated to the maximum … Read more
The error means that you have data in other tables that references the data you are trying to delete. You would need to either drop and recreate the constraints or delete the data that the Foreign Key references. Suppose you have the following tables dbo.Students ( StudentId StudentName StudentTypeId ) dbo.StudentTypes ( StudentTypeId StudentType ) … Read more
The closest you’ll get with the ORM is Book.objects.all().delete(). There are differences though: truncate will likely be faster, but the ORM will also chase down foreign key references and delete objects in other tables.
Try the following. It is pretty rudimentary. Just finds the first space starting at the desired length. public static string TruncateAtWord(this string value, int length) { if (value == null || value.Length < length || value.IndexOf(” “, length) == -1) return value; return value.Substring(0, value.IndexOf(” “, length)); }