-(NSString*) suffixNumber:(NSNumber*)number { if (!number) return @””; long long num = [number longLongValue]; int s = ( (num < 0) ? -1 : (num > 0) ? 1 : 0 ); NSString* sign = (s == -1 ? @”-” : @”” ); num = llabs(num); if (num < 1000) return [NSString stringWithFormat:@”%@%lld”,sign,num]; int exp = … Read more
Twitter dates in specific are interesting because they are relative only for the first day. After 24 hours they just show the month and day. After a year they start showing the last two digits of the year. Here’s a sample function that does something more akin to Twitter relative dates, though it always shows … Read more
Here’s one I wrote: /** * Format bytes as human-readable text. * * @param bytes Number of bytes. * @param si True to use metric (SI) units, aka powers of 1000. False to use * binary (IEC), aka powers of 1024. * @param dp Number of decimal places to display. * * @return Formatted string. … Read more
This may not the most efficient or optimized way to do it, but it’s easier to read if you are not familiar with log maths, and should be fast enough for most scenarios. string[] sizes = { “B”, “KB”, “MB”, “GB”, “TB” }; double len = new FileInfo(filename).Length; int order = 0; while (len >= … Read more
Is there any systematic step-by-step or mathematical way to construct SQL query from a given human-readable description? Yes, there is. It turns out that natural language expressions and logical expressions and relational algebra expressions and SQL expressions (a hybrid of the last two) correspond in a rather direct way. (What follows is for no duplicate … Read more